1、mysql查询两个日期之间的每一天
SELECT
@cdate := date_add(@cdate, INTERVAL + 1 DAY) days
FROM
(
SELECT
@cdate := #{startDay}
FROM
t_ct_customer
LIMIT ${dayCount}
) t1
2、使用查询结果中带逗号的字符串进行in查找的替代方案
使用FIND_IN_SET 来代替in
SELECT
a.id id,
a.type_name typeName,
a.type_id typeId,
a.create_time createTime,
a.create_by createBy,
a.role_id roleId,
(select GROUP_CONCAT(name) from t_sys_role where FIND_IN_SET(id, a.role_id) > 0 )roleName,
a.date_type dateType
FROM
t_xxx a
WHERE
a.id = 431