在一张表插入数据之后,在另一张表插入数据:
delimiter |
create trigger user_trigger
after insert on user
for each row
begin
insert into user_temp(username,password) values('123','123');
end |
在一张表插入数据之后,在另一张表插入数据:
delimiter |
create trigger user_trigger
after insert on user
for each row
begin
insert into user_temp(username,password) values('123','123');
end |