From: Martin Gainty
Date: July 6 2011 3:03pm
Subject: RE: dumb question?
List-Archive: http://lists.mysql.com/mysql/225332
Message-Id: <BLU142-W10E1A6DCBCE8F53DDF558AAE5E0@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="_2c8fa3c0-0bb6-48c0-baa4-b3fe4374ba6a_"

--_2c8fa3c0-0bb6-48c0-baa4-b3fe4374ba6a_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Rik and Crew
String values are always ticked VALUES('MYNAME') unless ANSI_QUOTES are ena=
bled
Column names are never surrounded by ticks or double quotes so
TABLE table_name
FOO VARCHAR(30)
</snip>
where the INSERT statement for table table_name column FOO would look like:
INSERT INTO table_name FOO VALUES('VALUES ARE ALWAYS SURROUNDED BY TICK MAR=
KS UNLESS ANSI_QUOTES ARE ENABLED')=3B

Bedankt=2C
Martin

> Subject: Re: dumb question?
> From: rik.wasmus@stripped
> To: mysql@stripped
> Date: Wed=2C 6 Jul 2011 16:39:16 +0200
>=20
> On Wed=2C 2011-07-06 at 16:27 +0200=2C Rik Wasmus wrote:
> > On Wed=2C 2011-07-06 at 07:15 -0700=2C XL Cordemans wrote:
> > > (error code) 1064
> > > (error message) HY000 [Actual][MySQL] You have an error in your SQL s=
yntax=3B check the manual that corresponds to your MySQL server version for=
 the right syntax to use near '"DMPPRuser") VALUES ('MYNAME')' at line 1=20
> >=20
> > You'll need to enable ANSI_QUOTES to be able the use '"' as an
> > identifier quote character rather then MySQL's default '`'.
> >=20
> > See:
> > http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ans=
i_quotes
>=20
> Oh=2C and if possible=2C go for even more standards-compliant:
> http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_ansi
>=20
> --=20
> Rik
>=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped=
om
>=20
 		 	   		  =

--_2c8fa3c0-0bb6-48c0-baa4-b3fe4374ba6a_--