Re: Move a column

2001-11-26 Thread Carl Troein
David Lidström writes: > Hi! > > Is it not possible to move a mysql column to after another existing > Column by using the CHANGE statement in ALTER TABLE? > >ALTER TABLE enum_test CHANGE ostron ostron int(4) NULL DEFAULT '0' > AFTER newCol_2 Moving oysters around, eh? :-) As far as I

Move a column

2001-11-26 Thread David Lidström
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 enu