创建表
创建定义、表选项、分区选项
Create (temporary) table (if not exists) customers
(
Cust_id int not null auto_increment,
Cust_name char(50) not null,
Cust_sex char(1) not null default 0,
Cust_address char(50) null,
Cust_contact char(50) null,
Primary key(cust_id)
)engine = InnoDB;
每个表只能有一个auto_increment列,并且它必须被索引,其值可以覆盖