Mysql move column sequence SQL statement _ MySQL

SQL statement bitsCN.com
The mysql database tool does not seem to have the ability to adjust the order of table columns, but we can use SQL statements. Statement: reference the alter table name modify field name field type after field example: 1. move the user_name column behind the password: Java code alter table employee modify user_name varchar (100) after password; 2. move the user_name column to the beginning: Java code alter table employee modify user_name varchar (100) first; author hanxin830311bitsCN.com