字符串拼接 字符串分割
select CONCAT(SUBSTR(descrip,1,2),'-',SUBSTR(descrip,2,3)) from t_map_info where id=1
SELECT
SUM(log_size) log_size,
DATE_FORMAT(log_date, '%Y-%m-%d') log_date
FROM
t_log_size
WHERE
conf_id = 32
AND log_date >= DATE_SUB(curdate(), INTERVAL 7 DAY)
GROUP BY
log_date
ORDER BY
log_date ASC
select DATE_SUB(curdate(), INTERVAL 7 DAY)
SELECT
tp.*, aa.check_name,
ta.app_name
FROM
t_page tp
LEFT JOIN (
将查出来的同一个page_id 对应多个check_name(即多条记录) 拼接成一条记录 check_name 用逗号隔开
SELECT
GROUP_CONCAT(tc.check_name) check_name,
tci.page_id page_id
FROM
t_check_info tci
LEFT JOIN t_check tc ON tc.id = tci.check_id
WHERE
tci.deleted = 0
GROUP BY
page_id
) aa ON tp.id = aa.page_id
LEFT JOIN t_app ta ON tp.app_id = ta.app_id
WHERE
tp.deleted = 0
AND aa.check_name LIKE '%f%'