Home     About author     Author CV     Contact us

How to move a column in MySQL

Posted 2010/11/16 – 1:42 pm in: Programming

Move a column after some other column mysql> ALTER TABLE mytable MODIFY COLUMN mycolumn INT AFTER someothercolumn; Move a column to the first position mysql> ALTER TABLE mytable MODIFY COLUMN mycolumn INT FIRST;

  No Comments  |  Tags: