MySQL Rearrange Columns
[Oct 18, 2010]
We can rearrange columns by running sql command like this...
Please note that, the type after column2 above is required. For example, varchar(50), int(11).
http://www.webmasterworld.com/forum112/501.htm
ALTER TABLE table_name MODIFY COLUMN column2 int(11) AFTER column1
Please note that, the type after column2 above is required. For example, varchar(50), int(11).
http://www.webmasterworld.com/forum112/501.htm