MySQL 修改表中的字段，使其自增

最新推荐文章于 2024-08-07 07:45:33 发布

weixin_30919571

最新推荐文章于 2024-08-07 07:45:33 发布

阅读量1.5k

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/Satu/p/10652044.html

版权

例如，我想使字段 id 自增。

1、查看表定义

mysql> DESC user;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| id       | int(8)      | NO   | PRI | NULL    |       |
| account  | varchar(16) | YES  |     | NULL    |       |
| password | varchar(16) | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+

2、更改表结构

mysql> ALTER TABLE user CHANGE COLUMN id id INT(8) NOT NULL AUTO_INCREMENT;

3、重新查看表定义

mysql> DESC user;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(8)      | NO   | PRI | NULL    | auto_increment |
| account  | varchar(16) | YES  |     | NULL    |                |
| password | varchar(16) | YES  |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+

转载于:https://www.cnblogs.com/Satu/p/10652044.html