Gray_code_element

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

Arduino HTTP Request

This worked on April 11, 2025 for an Arduino R4 using the Arduino Desktop IDE on a Windows 11 computer.  Make Sure that the Arduino IDE is u...