众所周知MySQL分组是不能排序的。所以order by不会起效,只会在分组后才排序。
解决:SELECT * FROM (SELECT * FROM user_message ORDER BY created DESC) m GROUP BY user_id
ORDER BY created DESC;
众所周知MySQL分组是不能排序的。所以order by不会起效,只会在分组后才排序。
解决:SELECT * FROM (SELECT * FROM user_message ORDER BY created DESC) m GROUP BY user_id
ORDER BY created DESC;