SQL Syntax: Create a Table CREatE TABLE table name( CREATE TABLE CUSTOMERS( column1 datatype, 工DTNT NOT NULL column2 datatype NAME VARCHAR(20) NOT NULL column3 datatype AGE INT NOT NULL ADDRESS CHAR(25), columnN datatype, SALARY DECIMAL (18, 2) PRIMARY KEY( one or more columns PRIMARY KEY (ID) ); ) Field Type Null Key DefaultExtra 工D int(11) NO PRI NAME varchar (20) N AGE ADDRESS char (25) YES NULL SAlary decimal(18, 2) YES NULLSQL Syntax: Create a Table 32 CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) ); CREATE TABLE CUSTOMERS( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , SALARY DECIMAL (18, 2), PRIMARY KEY (ID) ); +---------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------+------+-----+---------+-------+ | ID | int(11) | NO | PRI | | | | NAME | varchar(20) | NO | | | | | AGE | int(11) | NO | | | | | ADDRESS | char(25) | YES | | NULL | | | SALARY | decimal(18,2) | YES | | NULL | | +---------+---------------+------+-----+---------+-------+