Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement