我想在userinfo表插入数据的同时,向employee表也插入一条数据
请问触发器应该怎么写呀create trigger tri_addemployee before insert on userinfo
for each row begininsert into employee values(NEW.id);
请问触发器应该怎么写呀create trigger tri_addemployee before insert on userinfo
for each row begininsert into employee values(NEW.id);
先insert数据到userinfo表,在insert数据到employee表,如果employee表插入失败回滚,否则提交
create trigger tri_addemployee after insert on userinfo
for each row
begin
insert into employee values(NEW.id,NEW.field1,NEW....);
end||
delimiter ;