mysql常用方法

1、拼接两列字段

SELECT MIN(id) AS id,CONCAT_WS('/', `province`,`city`,`area`) AS title FROM `zq_street` WHERE deleted =0 GROUP BY `province`,`city`,`area` ORDER BY id DESC

2、分组去重复，然后合并成一行

SELECT MIN(id) AS id,GROUP_CONCAT(`province`,"/",`city`,"/",`area`) AS title FROM `zq_street` WHERE deleted =0 GROUP BY `province`,`city`,`area` ORDER BY id DESC

3、mysql查询前几天的时间

SELECT DATE_SUB('2012-09-01',INTERVAL 7 DAY) FROM zq_route;