Mysql - Change position of a column after another column
The column order in mysql is not very important in most of the cases, since the SELECT statement can create another column order, one specifically for the application being developed (but not the "SELECT *" statement).
But in cases where order is important, this command will change the position of "column_two" after "column_one".
Code:
mysql> ALTER TABLE table_name MODIFY column_two INT(11) UNSIGNED AFTER column_one;
_________________
VPSie - SSD VPS servers in AMS-IX, LINX, DE-CIX
https://vpsie.com