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`