>Hi,
>I am having a problem with a few "key words" on mysql.
> LEFT,DATABASE,FIELDS,LOAD,SEPARATOR ,SQL,KEY
>
>These are currently column names in our application tables.
>On other systems (oracle,sql server ect I can get around the problem by puting quotes around the identifiers. According to the mysql help this should be possible too. So I tried:
>
>mysql> CREATE TABLE TEST ('LEFT' INT);
>ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near ''LEF
>T' INT)' at line 1
>
>
>It seems this type of quotes " does not work nor does '.
>
>So the question is how do I get around this problem.
>
>BR
>Tim
I haven't used MySQL yet, but does using [] around the fields work?