纵有疾风起
人生不言弃

MySQL表添加自增列

mysql> create table zc_test2(id int);Query OK, 0 rows affected (1.37 sec)mysql> insert into zc_test2 values (10),(9),(8),(7),(6);Query OK, 5 rows affected (0.04 sec)Records: 5  Duplicates: 0  Warnings: 0mysql> select * from zc_test2;+------+| id   |+------+|   10 ||    9 ||    8 ||    7 ||    6 |+------+5 rows in set (0.00 sec)mysql> ALTER TABLE zc_test2 add id2 int;Query OK, 0 rows affected (2.84 sec)Records: 0  Duplicates: 0  Warnings: 0mysql> select * from zc_test2;+------+------+| id   | id2  |+------+------+|   10 | NULL ||    9 | NULL ||    8 | NULL ||    7 | NULL ||    6 | NULL |+------+------+5 rows in set (0.00 sec)mysql> alter table zc_test2 change id2 id2 int NOT NULL AUTO_INCREMENT;ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a keymysql> alter table zc_test2 change id2 id2 int NOT NULL AUTO_INCREMENT primary key;Query OK, 5 rows affected (1.34 sec)Records: 5  Duplicates: 0  Warnings: 0mysql> select * from zc_test2;+------+-----+| id   | id2 |+------+-----+|   10 |   1 ||    9 |   2 ||    8 |   3 ||    7 |   4 ||    6 |   5 |+------+-----+5 rows in set (0.00 sec)

 

文章转载于:https://www.cnblogs.com/zc_0101/p/9155631.html

原著是一个有趣的人,若有侵权,请通知删除

未经允许不得转载:起风网 » MySQL表添加自增列

分享到: 生成海报
avatar

评论 抢沙发

评论前必须登录!

立即登录   注册

切换注册

登录

忘记密码 ?

切换登录

注册

我们将发送一封验证邮件至你的邮箱, 请正确填写以完成账号注册和激活