mysql load data 的问题
请高手看看, 下面语句哪里错了, mysql提示出错。
load data local infile "c:/branche.asc"
into table branche_sst
fields terminated by '\t'
lines terminated by '\n'
(key,
displayname)
;
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 'key,
displayname)' at line 5
多谢大家。
------解决方案--------------------
KEY 是保留字 `key`