List:General Discussion« Previous MessageNext Message »
From:Rik Wasmus Date:July 6 2011 2:27pm
Subject:Re: dumb question?
View as plain text  
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

This can be done in the server configuration, so no client/lasso
alterations are necessary.
-- 
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