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.
>
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
