mysql 常用

查询最新一条

SELECT t.*
FROM your_table t
INNER JOIN (
    SELECT type, MAX(created_at) as latest
    FROM your_table
    GROUP BY type
) t2 ON t.type = t2.type AND t.created_at = t2.latest;