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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
