How to move a column in MySQL

7 Responses to How to move a column in MySQL

1. Tom Buchok says:

   June 11, 2009 at 6:54 pm

   Thanks a lot for this. Exactly what I needed.

   Reply
   • Aaron says:

     April 23, 2011 at 9:08 am

     Thanks!

     Reply
2. Paul says:

   July 30, 2011 at 2:28 am

   Thanks!

   So basically, if your column is of a type other than INT, you’ll need to remake it the way it was AFTER you move it. For ENUMs, copy-paste

   Reply
   • Liviu S says:

     August 15, 2011 at 12:54 am

     Actually it could be done in the same query. For example:
     ALTER TABLE mytable MODIFY COLUMN mycolumn VARCHAR(1000) AFTER someothercolumn;

     If you have data in the column you intend to move (varchar for example) you (may) lose it completely when moving and changing to INT.

     Thanks Masao

     Reply
3. TeamOneJ says:

   September 3, 2011 at 4:33 pm

   More accurately stated…

   Move a column after some other column

   mysql> ALTER TABLE `mytable` MODIFY COLUMN `mycolumn` [mycolumn definition] AFTER `someothercolumn`;

   Move a column to the first position

   mysql> ALTER TABLE `mytable` MODIFY COLUMN `mycolumn` [mycolumn definition] FIRST;

   ALTER TABLE Syntax

   Reply
4. Fitz says:

   May 10, 2012 at 11:36 am

   Thanks very much bro!

   Reply
5. siba prasad says:

   May 11, 2012 at 6:28 am

   THANK U MASAO…………..

   Reply