mysql大批量数据导出为CSV百万计数据导出

mysql大批量数据导出为CSV百万计数据导出

SELECT * FROM yechujundkgametop20bymonth  WHERE  gamename='征途2S'
AND monthkey=201211
INTO OUTFILE 'D:/ztdk11.csv'  
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"'  
LINES TERMINATED BY '\r\n';

/* 当有NULL 的时候格式会变*/

UPDATE  yechujunybgametop20bymonth SET buyerqq='未知'
WHERE buyerqq IS NULL

posted on 2012-12-26 13:16 kingstudy 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/wxjnew/archive/2012/12/26/kingstudy.html