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