> > The syntax "sixth" is not a supported syntax. You should use the syntax > "AFTER <column_name>" where you replace <column_name> with the column name > you want to position the modified column after.
Oh thanks. That's actually what I ended up doing after I got frustrated with that error. I was following the book 'Head First SQL' which was suggesting that you could do something like what this user was trying in this stack overflow thread: http://stackoverflow.com/questions/19175240/re-arranging-columns-in-mysql-using-position-keywords-such-as-first-second But the answer in that thread too suggests that this is wrong. So is the Head First SQL book just referring to an outdated syntax that doesn't work anymore? I can't imagine that it never worked if it's in that book. But hey ya never know! ;) Thanks Tim On Sat, Jun 28, 2014 at 7:46 PM, Jesper Wisborg Krogh <my...@wisborg.dk> wrote: > Hi Tim, > > > -----Original Message----- > > From: Tim Dunphy [mailto:bluethu...@gmail.com] > > Sent: Sunday, 29 June 2014 03:45 > > Cc: mysql@lists.mysql.com > > Subject: Re: alter table modify syntax error > > > > Hey guys, > > > > Sorry to hit you with one more. But I'm trying to use a positional > statement > > in a column move based on what you all just taught me: > > > > mysql> alter table modify column color varchar(10) sixth; > > > > But I am getting this error: > > > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual > > that corresponds to your MySQL server version for the right syntax to use > > near 'column color varchar(10) sixth' at line 1 > > The syntax "sixth" is not a supported syntax. You should use the syntax > "AFTER <column_name>" where you replace <column_name> with the column name > you want to position the modified column after. > > See also: https://dev.mysql.com/doc/refman/5.5/en/alter-table.html > > Best regards, > Jesper Krogh > MySQL Support > > > -- GPG me!! gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B