General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only