UPDATE tire_repair a
JOIN tire_info b ON b.tireNo=a.tireNo
SET a.tireId = b.id
WHERE b.tireNo=a.tireNo
成功后将tire_info表的 b.id赋值给tire_repair表的a.tireId;
UPDATE tire_repair a
JOIN tire_info b ON b.tireNo=a.tireNo
SET a.tireId = b.id
WHERE b.tireNo=a.tireNo
成功后将tire_info表的 b.id赋值给tire_repair表的a.tireId;