List:General Discussion« Previous MessageNext Message »
From:Tim Dunphy Date:June 29 2014 12:09am
Subject:Re: alter table modify syntax error
View as plain text  
>
> 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 <mysql@stripped>
wrote:

> Hi Tim,
>
> > -----Original Message-----
> > From: Tim Dunphy [mailto:bluethundr@stripped]
> > Sent: Sunday, 29 June 2014 03:45
> > Cc: mysql@stripped
> > 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

Thread
alter table modify syntax errorTim Dunphy28 Jun 2014
  • Re: alter table modify syntax errorCarsten Pedersen28 Jun 2014
    • Re: alter table modify syntax errorTim Dunphy28 Jun 2014
      • Re: alter table modify syntax errorTim Dunphy28 Jun 2014
        • RE: alter table modify syntax errorJesper Wisborg Krogh28 Jun 2014
          • Re: alter table modify syntax errorTim Dunphy29 Jun 2014
            • RE: alter table modify syntax errorJesper Wisborg Krogh29 Jun 2014
              • Re: alter table modify syntax errorTim Dunphy29 Jun 2014