mysql 列顺序_mysql数据库中如何改变列顺序呢？

摘要:

下文讲述在mysql数据库中修改列顺序的方法分享，如下所示:

今天我接到了领导一个需求：

将原有数据表 “指定列”调整到“某某列”前面,下文通过举例的方式进行一一讲解，如下所示:

---1.创建数据表 “maomao365.com”,包含列名(infoa,infob,keyId)

mysql> create table `maomao365.com`

-> (infoa varchar(10),infob varchar(10),keyId int);

---2.在数据表中插入数据

mysql> insert `maomao365.com`(infoa,infob,keyId)values('a','b',1);

Query OK, 1 row affected (0.00 sec)

mysql> insert `maomao365.com`(infoa,infob,keyId)values('a1','b1',2);

Query OK, 1 row affected (0.00 sec)

mysql> insert `maomao365.com`(infoa,infob,keyId)values('a2','b2',3);

Query OK, 1 row affected (0.00 sec)

mysql> select * from `maomao365.com`;

+-------+-------+-------+

| infoa | infob | keyId |

+-------+-------+-------+

| a | b | 1 |

| a1 | b1 | 2 |

| a2 | b2 | 3 |

+-------+-------+-------+

3 rows in set (0.00 sec)

---3.使用alter 将列keyId 调整至 infoa列的前面

mysql> alter table `maomao365.com` modify infoa varchar(10) after keyId;

Query OK, 3 rows affected (0.00 sec)

Records: 3 Duplicates: 0 Warnings: 0

mysql> alter table `maomao365.com` modify infoa varchar(10) after keyId;

---4.重新查看数据表

mysql> select * from `maomao365.com`;

+-------+-------+-------+

| keyId | infoa | infob |

+-------+-------+-------+

| 1 | a | b |

| 2 | a1 | b1 |

| 3 | a2 | b2 |

+-------+-------+-------+

3 rows in set (0.00 sec)