创建:
mysql>create table cc(id int auto_increment,name varchar(20),primary key(id));
修改:
mysql> alter table cc change id id int primary key auto_increment;注:只有int类型且为primary key 才可以使用auto_increment.
mysql>create table cc(id int auto_increment,name varchar(20),primary key(id));
修改:
mysql> alter table cc change id id int primary key auto_increment;注:只有int类型且为primary key 才可以使用auto_increment.
mysql> insert into t1 values("e23132");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql>