CREATE TRIGGER rttest AFTER INSERT ON t_coursemanage FOR EACH ROW INSERT INTO t_score(teacherid,courseid) values(NEW.teacherid, NEW.courseid);
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 ;
FOR EACH ROW
INSERT INTO t_score SET teacherid = NEW.teacherid,courseid = NEW.courseid;
AFTER INSERT ON t_coursemanage
FOR EACH ROW
INSERT INTO t_score(teacherid,courseid) values(NEW.teacherid, NEW.courseid);
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 ;