mysql没有的话替换
select IFNULL(real_name,nickname),COUNT(*) from tbl_invites JOIN tbl_teachers on tbl_invites.from_teacher_id = tbl_teachers.id GROUP BY from_teacher_id;
- 上一篇: 如何检测MySQL中建立的索引是否生效
- 下一篇: LaravelModel关联模型注意事项
select IFNULL(real_name,nickname),COUNT(*) from tbl_invites JOIN tbl_teachers on tbl_invites.from_teacher_id = tbl_teachers.id GROUP BY from_teacher_id;