读书人

mysql load data 的有关问题

发布时间: 2012-03-23 12:06:21 作者: rapoo

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`

读书人网 >Mysql

热点推荐