案例;
SELECT hotel_code,rate_plan_code,list_price,tab_rate_plan.end FROM tab_rate_plan
INTO OUTFILE 'C:\\Users\\Administrator\\Desktop\\hotelPrice.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n';本文共 293 字，大约阅读时间需要 1 分钟。
案例;
SELECT hotel_code,rate_plan_code,list_price,tab_rate_plan.end FROM tab_rate_plan
INTO OUTFILE 'C:\\Users\\Administrator\\Desktop\\hotelPrice.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n';转载于:https://my.oschina.net/u/1174884/blog/215822