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

Making Stairs with Landing Revit

 This is a really good video, super simple for making stairs in revit with a landing: https://www.youtube.com/watch?v=mjY1uNw1G-0&ab_cha...