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