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;
y + hold Alt, type 0773
No comments:
Post a Comment