下面是我的模式查询
SELECT COUNT(IF(n.status='0',1, NULL)) as counter, n.notify_from, n.notify_to, n.status, n.notify_text, n.notify_id, n.notify_type, n.notify_time, r.user_name, r.user_image, r.user_gender FROM `notifications` AS n JOIN register r ON n.`notify_from` = r.unique_user_name WHERE n.`notify_to` = 'IzaazG' AND n.`notify_type` = '6' GROUP BY n.`notify_from` ORDER BY n.`notify_id` DESC
从这个查询中,我无法从通知表中获取最后一条记录。
发布于 2018-08-19 03:41:52
从函数COUNT中删除IF条件并尝试使用case语句
https://stackoverflow.com/questions/51911850
复制相似问题