• CREATE [database] -- DBA only
• CREATE TABLE mytablename (id int, fname varchar(30), surname varchar(30));
• CREATE TABLE mytablename (id int UNIQUE AUTO_INCREMENT, fname varchar(30), surname varchar(30) NOT NULL, PRIMARY KEY(id))
• CREATE TABLE mytablename (id int UNIQUE AUTO_INCREMENT, fname varchar(30) DEFAULT 'jorge', surname varchar(30) NOT NULL, PRIMARY KEY(id))
• CREATE TABLE syntax reference
NEXT
PREVIOUS
Master Index