最近刚刚开始学习研究触发器,以此记录,小伙伴们有更多更好的方式方法,欢迎指教
多表关联
BEGIN
--通过where条件代替join获取所需字段信息
select car_no from table_1 where vin= new.vin into @car_no;
select brand from table_1 where vin= new.vin into @brand;
insert into table_2 value (new.vin,
@car_no,
@brand,
'燃油',
new.datetime
);
END