Mysql按照某个字段查最新一条的记录

首先，建表的时候需要建立自增primary key作为id
比如我们有一张自行车开关锁记录表tb_bike_record，车牌号码是bike_no，要查每个车牌最新一条的记录。

我们可以这么写：

select b.* 
from
  (select max(`id`) as id from `tb_bike_record` group by `bike_no`) as a
join `tb_bike_record` as b on a.id = b.id;