Database

Database and Table · Create Database CREATE DATABASE <database name>; CREATE DATABASE shop; · Create Table CREATE TABLE <table name> (<column name> <data type> <constrains>, <column name> <data type> <constrains>, …, <constrains of the table>,<constrains of the table>,…); CREATE TABLE product (id CHAR(4) NOT NULL, name VARCHAR(100) NOT NULL, price Read more…