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;

  Tags:
Trackbacks are closed, but you can post a comment

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

*