mysql语句记录

导出数据到csv文件

SELECT a,b,c FROM my_table INTO OUTFILE '/a.csv' 
FIELDS TERMINATED BY ';' 
ESCAPED BY ''
LINES TERMINATED BY '\n';

日期计算

DATE_SUB('2013-04-21 00:00:00', INTERVAL 7 DAY)

insert into ...select...语句，要求目标表必须存在

insert into userinfo_bak(id,name,age) select id,name,age from userinfo

select into... from...语句，目标表可以不存在，插入时会自动创建表。

SELECT name,age into userinfo_bak from userinfo

未完待续。。。