展开全部
应该是因为default的原因。
建议调整为:alter table student2 modify column id int(10) not null primary key auto_increment;
alter table student2 auto_increment = 1 ;
或者直接在建表的时候指定自增62616964757a686964616fe4b893e5b19e31333365633933标识drop table student2;
CREATE TABLE IF NOT EXISTS `student2`(
`id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
`username` VARCHAR(20),
`gender` VARCHAR(40)
)ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
检查一个表上的自增标识SELECT
t.TABLE_NAME,
c.COLUMN_NAME,
ts.AUTO_INCREMENT
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS t,
information_schema.TABLES AS ts,
information_schema.KEY_COLUMN_USAGE AS c
WHERE
t.TABLE_NAME = ts.TABLE_NAME
AND ts.TABLE_NAME = c.TABLE_NAME
AND ts.TABLE_NAME = 'student2'
AND t.TABLE_SCHEMA = 'demo'
AND t.CONSTRAINT_TYPE = 'PRIMARY KEY'
ORDER BY ts.`AUTO_INCREMENT` DESC;