Mysql sql

字符串拼接 字符串分割

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%'