如题,不知道有没有人跟我有一样的写SQL习惯,把逗号放在SELECT中每个字段的前面,在调试SQL注释某一行的时候很方便
SELECT
su.id
,su.name
,su.account
,su.phone
,su.status
,zu.name AS updateName
,su.update_time
,GROUP_CONCAT(zp.name SEPARATOR ',') AS projectNames
FROM
sg_user su
LEFT JOIN zj_user zu ON su.update_by = zu.id
LEFT JOIN sg_user_project sup ON sup.user_id = su.id
LEFT JOIN zj_project zp ON sup.project_id = zp.id
WHERE
su.del_flag = 1
AND su.company_id = 1
AND su.role_id != (SELECT id FROM sg_role sr WHERE sr.`level` = 1)
GROUP BY
su.id