mysql 导出表格或文本

SELECT * INTO OUTFILE '/tmp/test.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM userinfo;

SELECT * ,from_unixtime( createtime ) INTO OUTFILE '/tmp/test1.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM userinfo;

可以在导出时转换时间戳

格式

导出：

SELECT * INTO OUTFILE 'e:/test.txt'                数据保存的位置

FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ' " '        字段之间的分隔符，字段用双引号引起来(数字类型除外)

LINES TERMINATED BY '\n'        每行用换行符结束

FROM　DBNAME.TABLENAME