菜鸟一名

原创 最近遇到的mysql查询的问题

1.每个用户取一条最晚数据的mysql查询方法() select * from where in (select max(id) from group by userid) 2.删除重复数据(只剩下一条)的方法 delete a from a left join (select max(id) as id from group by )b on a.id = b.id where