56,679
社区成员
发帖
与我相关
我的任务
分享
delimiter //
create trigger trigger_test after insert on t_coursemanage
for each row begin
insert into t_score(teacherid ,courseid) values(new.teacherid,new.courseid);
end;
//
delimiter ;
CREATE TRIGGER rttest
AFTER INSERT ON t_coursemanage
FOR EACH ROW
INSERT INTO t_score(teacherid,courseid) values(NEW.teacherid, NEW.courseid);
CREATE TRIGGER testref AFTER INSERT ON t_coursemanage
FOR EACH ROW
INSERT INTO t_score SET teacherid = NEW.teacherid,courseid = NEW.courseid;