Sunday, November 7, 2010

Moving Columns in MySQL

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;



Thanks to Masao Kitamura

No comments:

Post a Comment

VBA Excel to Double Click change to checkmark or x

 Note that to do this, you need to set the font of the affected cells to Winding 2 first: 1 2 3 4 5 6 7 8 9 10 11 12 Private Sub Worksheet...