alter table syntax error

Gary, Monday, February 18, 2002, 2:30:03 PM, you wrote: GP> I've read and re-read the manual and searched mailing list archive and still GP> can't see what is wrong with this statement - I'm sure someone can put me GP> out of my misery ! I'm simply trying to move the position of the Cat2 GP> col

alter table syntax error

I've read and re-read the manual and searched mailing list archive and still can't see what is wrong with this statement - I'm sure someone can put me out of my misery ! I'm simply trying to move the position of the Cat2 column. mysql> alter table bollinks3 change Cat2 Cat2 smallint(5) unsigned n