Re: alter table move column syntax error

[Muhammad Habibullah]

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;

▁ ▂ ▄ ▅ ▆ ▇ █ MY BLOG on Passive Income http://how-2-earn.tk █ ▇ ▆ ▅ ▄ ▂ ▁