load file 读取无效时
连接mysql写入:
mysql> load data local infile "/etc/passwd" into table test FIELDS TERMINATED BY ‘\n‘; //test 表名 或者 "C:/Windows/win.ini" Query OK, 11 rows affected, 11 warnings (0.01 sec) Records: 11 Deleted: 0 Skipped: 0 Warnings: 1
前台执行:select * from `test`