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

OneNote Math Operations

  Supported arithmetic operators Operator Meaning Example +  (plus sign) Addition 3+3 -  (minus sign) Subtraction Negation 3-1 -1 *  (asteri...