WHERE DATE_SUB(CURDATE(), INTERVAL 3 MONTH) <= DATE(av_in_time)
DELETE FROM test
WHERE id NOT IN
(
SELECT id FROM
(
SELECT MIN(id) id FROM test GROUP BY aa
) t
)
分组查询链接数据
group_concat(t6.name) escOrgName
GROUP BY t6.id
把日期格式化
date_format(t1.created,'%Y-%m-%d %H:%i:%s') as created,