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 http://www.mysql.com/doc/L/e/Legal_names.html
>for more info.
>
>Bye,
>
> Benjamin.
>
>On Wed, Apr 10, 2002 at 07:39:52PM +0100, [EMAIL PROTECTED] wrote:
>
>>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 cannot get it to work though.
>>
>>MySQL is installed on Linux, and if I try to enter the following create
>>table statement to the MySQL client, it objects to the first quote
>>(either double or single quotes).
>> CREATE TABLE TEST ('ID' INTEGER);
>>while
>> CREATE TABLE TEST (ID INTEGER);
>>works as expected.
>>
>>I must be doing something stupid :), but I can't see it.
>>
>[...]
>
--
Nick Read.
______________________________________________________________________
The information contained in this message is confidential and may also
be privileged. It is intended only for the addressee named above. The
unauthorised use, disclosure, copying or alteration of this message is
strictly prohibited. If you are not the addressee (or responsible for
delivery of the message to the addressee), please notify the originator
immediately by return message and destroy the original message.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
