Hi Tim, > -----Original Message----- > From: Tim Dunphy [mailto:bluethu...@gmail.com] > Sent: Sunday, 29 June 2014 10:09 > To: Jesper Wisborg Krogh > Cc: mysql@lists.mysql.com > Subject: Re: alter table modify syntax error > > > > > 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! ;)
Given the title of the book is "Head First SQL" and not "Head First MySQL" it probably isn't exclusively using syntax for MySQL. While SQL is a standard the various SQL databases are not completely identical with the syntax they support. This may be due to not completely conforming to the standard, using different versions of the SQL standard, or that there is not standard for that operation. Best regards, Jesper Krogh MySQL Support -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql