56,687
社区成员
发帖
与我相关
我的任务
分享
delimiter $$
drop trigger if exists addStudent$$
create trigger addStudent
AFTER INSERT ON student
FOR EACH ROW
begin
insert into borrowstudent(StudentID,city) values(new.StudentID,elt( new.city,'china','english','USA'));
end$$
delimiter ;
delimiter $$
drop trigger if exists addStudent$$
create trigger addStudent
AFTER INSERT ON student
FOR EACH ROW
begin
insert into borrowstudent(StudentID,city) values(new.StudentID,case
when new.city=1 then 'china'
when new.city=2 then 'english'
when new.city=3 then 'USA'
end);
end$$
delimiter ;