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

JSP - Java Description

https://docs.oracle.com/javaee/5/tutorial/doc/bnair.html Install Java on the computer:  https://phoenixnap.com/kb/install-java-windows Insta...