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 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
>
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
