weixin_42231208的博客

场景：我要查询出fund_info表里某个身份证号所有记录的最新一条，然后修改它的endtime update fund_info set end_time=NOW() where end_time in ( select a.end_time FROM ( SELECT max(id) ,end_time from fund_info WHERE identity_no='110101199003077555' ) a) ...