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