修改表字段的顺序

最新推荐文章于 2023-11-07 16:28:48 发布

hello一二三

最新推荐文章于 2023-11-07 16:28:48 发布

阅读量977

点赞数

分类专栏： MySQL 文章标签： linux centos 服务器 dba 数据库架构

本文链接：https://blog.csdn.net/qq_40880022/article/details/121655736

版权

MySQL 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

1、先查看表结构
mysql> desc office;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| city        | varchar(50)      | NO   |     |         |                |
| address     | varchar(50)      | YES  |     | NULL    |                |
| country     | varchar(50)      | NO   |     |         |                |
| postal_code | varchar(15)      | YES  | UNI | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

2、要求：将country 放到 city 字段的前面
说明：使用关键字 after
mysql> ALTER TABLE `office` MODIFY COLUMN `country` VARCHAR(50) NOT NULL AFTER id;
Query OK, 0 rows affected (0.27 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> DESCRIBE `office`;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| country     | varchar(50)      | NO   |     | NULL    |                |
| city        | varchar(50)      | NO   |     |         |                |
| address     | varchar(50)      | YES  |     | NULL    |                |
| postal_code | varchar(15)      | YES  | UNI | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

3 将 postal_code 放到最前面

mysql> ALTER TABLE `office` MODIFY COLUMN `postal_code` VARCHAR(15) COMMENT '邮政编码' FIRST;
Query OK, 0 rows affected (0.20 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> DESCRIBE `office`;
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| postal_code | varchar(15)      | YES  | UNI | NULL    |                |
| id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| country     | varchar(50)      | NO   |     | NULL    |                |
| city        | varchar(50)      | NO   |     |         |                |
| address     | varchar(50)      | YES  |     | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql>