mysql load data 的有关问题

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 load data 的有关问题

相关文章:

你感兴趣的文章:

标签云: