List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:July 6 2011 2:39pm
Subject:Re: dumb question?
View as plain text  
On Wed, 2011-07-06 at 16:27 +0200, Rik Wasmus wrote:
> On Wed, 2011-07-06 at 07:15 -0700, XL Cordemans wrote:
> > (error code) 1064
> > (error message) HY000 [Actual][MySQL] 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 '"DMPPRuser") VALUES ('MYNAME')' at line 1 
> 
> You'll need to enable ANSI_QUOTES to be able the use '"' as an
> identifier quote character rather then MySQL's default '`'.
> 
> See:
> http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi_quotes

Oh, and if possible, go for even more standards-compliant:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi

-- 
Rik


Thread
dumb question?XL Cordemans6 Jul
  • Re: dumb question?Rik Wasmus6 Jul
    • Re: dumb question?Rik Wasmus6 Jul
      • RE: dumb question?Martin Gainty6 Jul
        • RE: dumb question?Rik Wasmus6 Jul
    • Re: dumb question?XL Cordemans7 Jul
      • Re: dumb question?hsv7 Jul