mysql php 导入数据出错

php 尝试import 数据量较大的csv file时报错,这个file有两行的header

A symbol name was expected! A reserved keyword can not be used as a column name without backquotes. (near "varchar" at position 52)
At least one column definition was expected. (near "varchar" at position 52)
Unexpected beginning of statement. (near "10" at position 60)
Unexpected beginning of statement. (near "ESP01" at position 65)
Unrecognized statement type. (near "varchar" at position 73)

请问这个csv数据怎么才能import进去?

错误原因:

(1)检查数据表的各个字段拼写是否正确;

(2)检查插入的变量的值,使用语句var_dump($xxx),查看此变量值格式、数值是否正确;

(3)检查数据表的NULL字段,使用命令desc table_name,当某一个或多个字段属性为 not null 时,而却没有数据插入,则会导致插入数据错误。
(4)打印sql语句,复制到phpMyAdmin执行,查看是否成功。