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 meanin
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 10
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 My
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 can
