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]

Reply via email to