点击(此处)折叠或打开
-
DROP TABLE IF EXISTS tb_incre_innodb;
-
CREATE TABLE tb_incre_innodb(
-
id INT NOT NULL AUTO_INCREMENT,
-
age INT NOT NULL,
-
/*[PRIMARY | UNIQUE]*/ KEY (id)
-
)ENGINE=INNODB;
-
-
DROP TABLE IF EXISTS tb_incre_myisam;
-
CREATE TABLE tb_incre_myisam(
-
id INT NOT NULL AUTO_INCREMENT,
-
ty INT NOT NULL ,
-
age INT NOT NULL,
-
/*[PRIMARY | UNIQUE]*/ KEY (id) /*(ty, id) | (id) */
-
)ENGINE=INNODB;
-
-
/*
-
自增列位于联合索引非首列，自增值连续自增，而不是在前缀列下自增
-
*/
-
DROP TABLE IF EXISTS tb_incre_myisam_unhead_excp;
-
CREATE TABLE tb_incre_myisam_unhead_excp(
-
ty INT NOT NULL ,
-
id INT NOT NULL AUTO_INCREMENT,
-
age INT NOT NULL,
-
PRIMARY KEY (ty, id),
-
KEY (id)
-
)ENGINE=INNODB ;
-
INSERT INTO tb_incre_myisam_unhead_excp(ty,age) VALUES (1,1),(1,2),(2,3);
- SELECT * FROM tb_incre_myisam_unhead_excp;