批量刷数据sql

update t_free_m**  m set m.plate_no = (
select v.plate_num from t_wh_vehi*** v where v.vin = m.car_vin )
where m.plate_no = '';

转载于:https://www.cnblogs.com/beixiaoyi/p/11510707.html