ALTER TABLE TableName MODIFY COLUMN ColumnNameToMove longtext AFTER ColumnNameToPutAfter
Note that long text is required (put in the correct column type you intend to move) Alternate: INSERT INTO new_table SELECT columns-in-new-order FROM old_table; DROP table old_table; ALTER TABLE new_table RENAME old_table; On Mon, 14 Mar 2005 23:54:56 +0000, shaun thornburgh <[EMAIL PROTECTED]> wrote: > Hi, > > Is it possible to change the order of columns in a table after the table has > been created? > > Thanks for your help > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
