这与版本无关,我看了文档这是可以设置的
--------------------------------------------------------------------------------
If you build MySQL from source but don't use the --enable-local-infile option to configure, LOAD DATA LOCAL cannot be used by any client unless it is written explicitly to invoke mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0). See section 21.2.3.167 mysql_options().
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
If you build MySQL from source but don't use the --enable-local-infile option to configure, LOAD DATA LOCAL cannot be used by any client unless it is written explicitly to invoke mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0). See section 21.2.3.167 mysql_options().
--------------------------------------------------------------------------------
解决方案 »
- 求批量更新MySQL语句
- php+mysql中读取一个表的数据后写入别一个表报字符格式出错
- 查询按类别分组后每组的最新20条数据
- 请教SQL中一个特殊运算符(+)的含义
- 求ado 连接 Postgresql (加急)
- Sybase与mysqldecimal类型的转换 急...............
- 难问题.不通过程序,而直接sql语句删除掉数据库重复记录的数据.比如ID相同的就删除掉.
- zerofill是什么意思??
- shuixin13(犬犬(心帆)) :请问mysql中的查询问题
- 动态建表的问题
- 当我的查询mysql数据库中的海量数据select count(*) 巨慢,有其他的方法得到记录数吗?
- 在问mysql中password?密码修改后就变卦了,
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]