Hi,
I'm using MySQL version 3.23.37 which works fine. However I am
currently trying to convert a MS Access database to MySQL and some of
the column names have embedded spaces i.e. First Name. Now according
to the manual MySQL supports quoting of identifiers (for the above
reason), I
ANSI92 states that quoted identifiers are delimited by double quotes
-Original Message-
From: Nicholas A Read [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 10 Apr 2002 19:39:52 +0100
Subject: Mysql and Quoted Identifiers
Hi,
I'm using MySQL version 3.23.37 which works
Hi.
You have to use backticks (`) instead of single quotes (') as in
CREATE TABLE TEST (`ID` INTEGER)
When MySQL has been started with --ansi, double quotes () will have
the same meaning. See http://www.mysql.com/doc/L/e/Legal_names.html
for more info.
Bye,
Benjamin.
On Wed, Apr
Thanks
This is not clear from the manual. - Works fine now though.
Benjamin Pflugmann wrote:
Hi.
You have to use backticks (`) instead of single quotes (') as in
CREATE TABLE TEST (`ID` INTEGER)
When MySQL has been started with --ansi, double quotes () will have
the same meaning. See