Move a column

[David Lidström <david.lidstrom@xxxxxxx>]

 Hi!

Is it not possible to move a mysql column to after another existing
Column by using the CHANGE statement in ALTER TABLE?

I have the following columns:
 id
 ostron
 newCol_2

And I'd like to move the "ostron"-column to after the newCol_2 column.

Is this not the syntax?
  
   ALTER TABLE enum_test CHANGE ostron ostron int(4)  NULL DEFAULT '0'
AFTER newCol_2

\david



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92254@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php