mysql导入导出文件

LOAD DATA LOCAL INFILE 'E:\\code\\Billing\\T.txt' INTO TABLE wlog FIELDS TERMINATED BY ',' (txt,updt)
select txt,updt into outfile 'E:\\code\\Billing\\T2.txt' FIELDS TERMINATED BY ',' from wlog --找不到
select txt,updt into outfile '/tmp/t2.txt' FIELDS TERMINATED BY ',' from wlog

注意文件是在本机还是mysql服务器上？

 

mysql.data.dll

5.0.x - mysql 5.0 ok, 之前一直用, 连接mysql 5.5+失败

5.6.x - mysql 5.5+ 成功