mysql add primary key auto_increment

posted | in | visitors: |
| wordcount: 91 | min2read ≈ 1
MySQL add primary key auto_increment for established table

添加字段id,并将其设置为主键自增

  • alter table TABLE_NAME add id int not null primary key Auto_increment

如果想添加已经有了一列为主键，可以用：

  • alter table TABLE_NAME add primary key(COL_NAME);

  • 如果想修改一列为主键，则需要先删除原来的主键：

alter table TABLE_NAME drop primary key;

再重新添加主键：

  • alter table TABLE_NAME add primary key(COL_NAME);
-------------The End-------------

Title:mysql add primary key auto_increment

Author:cloud sjhan

Publish Time:2018年12月25日 - 19:12

Last Update:2018年12月25日 - 19:12

Original Link:https://cloudsjhan.github.io/2018/12/25/mysql-add-primary-key-auto-increment/

License: By-NC-ND 4.0 international。

cloud sjhan wechat
subscribe to my blog by scanning my public wechat account
keep going, keep coding
0%
;