Re: Mysql and Quoted Identifiers

2002-04-10 Thread Nicholas A Read
Thanks This is not clear from the manual. - Works fine now though. Benjamin Pflugmann wrote: > >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 meanin

Mysql and Quoted Identifiers

2002-04-10 Thread Nicholas A Read
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 can