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/mysql?unsub=arch...@jab.org