Can we change the order of columns in MySQL?

Yes, we can change the order of the columns. This can be done using the ALTER command and the AFTER command to set a new order for individual columns. Let us first create a table -

mysql> create table DemoTable
   -> (
   -> `Student_Key_Age` int,
   -> `Student_Key_Name` varchar(20),
   -> `Student_Key_CountryName` varchar(20)
   -> );
Query OK, 0 rows affected (0.64 sec)

The following is the query to change the column order -

mysql> alter table DemoTable modify column `Student_Key_Age` int after `Student_Key_Name`;
Query OK, 0 rows affected (1.15 sec)
Records: 0 Duplicates: 0 Warnings: 0

Let us check the table description again -

mysql> desc DemoTable;

This will produce the following output. As you can see, the order of the columns has changed -

+-------------------------+-------------+------+-----+---------+-------+
| Field                   | Type        | Null | Key | Default | Extra |
+-------------------------+-------------+------+-----+---------+-------+
| Student_Key_Name        | varchar(20) | YES  |      | NULL   |       |
| Student_Key_Age         | int(11)     | YES  |      | NULL   |       |
| Student_Key_CountryName | varchar(20) | YES  |      | NULL   |       |
+-------------------------+-------------+------+-----+---------+-------+
3 rows in set (0.11 sec)

The above is the detailed content of Can we change the order of columns in MySQL?. For more information, please follow other related articles on the PHP Chinese website!