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
