Deal all, I am migrating an old Access database to MySQL. After migration, we'll keep using Access forms as front end, and MySQL as database.
I experienced a strange problem when creating table with a column name "id #", which is used by many queries in Access. My command is like this: create table t1 (`id #` int(11), `First Name` varchard(20) ); I get this error:ERROR 1064: You have an error in your SQL syntax near '' at line 1 Once I substituted # to ! or @, the command worked fine. Is there any constraints with '#' for the column name? Thanks Richard ===== Richard Zhang(Msc, B.E., OCA, OCP, CCNA) SOHO Computer Care, your "part-time IT department". http://www.sohopccare.com __________________________________ Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ http://photos.yahoo.com/ph/print_splash -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]