不用指定后面的参数,直接就是:
select * from admin into outfile "a.txt"如果非要指定参数,也要完全才有用:select * from admin into outfile "a.txt" field terminated by "," enclosed by "#" lines terminated by "/n";
select * from admin into outfile "a.txt"如果非要指定参数,也要完全才有用:select * from admin into outfile "a.txt" field terminated by "," enclosed by "#" lines terminated by "/n";
你再仔细检查一下。 :)
一个 ASCII 10 换行符。
\r
一个 ASCII 13 回车符。
SELECT * INTO OUTFILE "a.txt"
FIELDS TERMINATED BY ','
LINES TERMINATED BY "\r\n"
FROM admin ;
只是在一条记录结束后,显示一个黑色的矩形
这是由于你用的是记事本打开的,
在 WIN32 下,它无法将一个换行符正确换行,如果你用UltraEdit就可以正确显示了,注意用上面的语句后,你的恢复语句也要做相对应的修改
".tx"不成功的原因就如心帆说得一样.谢谢了.马上给分.