MySQL创建表时可以做哪些事情

1、指定字段及其类型：CREATE TABLE t1( a INT, b CHAR(20));

3、指定单字段主键：CREATE TABLE t1( a INT, b CHAR(20), PRIMARY KEY (a)) ENGINE=InnoDB;

5、指定组合主键：CREATE TABLE t1( id INT AUTO_INCREMENT, a INT, b CHAR(20), PRIMARY KEY (id,a)) ENGINE=InnoDB;

7、指定行格式：CR苇质缵爨EATE TABLE t1( id INT AUTO_INCREMENT, a INT, b CHAR(20), PR朐袁噙岿IMARY KEY (id,a))TABLESPACE ts1ROW_FORMAT=DYNAMICENGINE=InnoDB;