mysql/sql 触发器的使用

mysql触发器在项目中的使用

触发器A:
ssc_she_log随着ssdb_she_log的新增而新增

delimiter $
drop trigger if exists after_insert_on_ssdb_she_log$
create trigger after_insert_on_ssdb_she_log
after insert on ssdb_she_log
for each row
begin
insert into ssc_she_log (dataline,price,state) values (new.dataline,new.price,new.state);
end$

触发器B:
ssc_she随着ssdb_she的更新而更新

delimiter $
drop trigger if exists after_update_on_ssdb_she$
create trigger after_update_on_ssdb_she
after update on ssdb_she
for each row 
begin
update ssc_she set price=new.price where id=old.id;
end$