MySQL KeyWords WorkAround

[Tim McConechy]

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