Mysql 修改某个字段为自增
Alter table xxxxxx add primary key(`id`);
alter table xxxxxx auto_increment = 1;
----------------
SELECT auto_increment from information_schema.TABLES where TABLE_name = 'xxxxxx'这里显示的仍然是null
Alter table xxxxxx add primary key(`id`);
alter table xxxxxx auto_increment = 1;
----------------
SELECT auto_increment from information_schema.TABLES where TABLE_name = 'xxxxxx'这里显示的仍然是null