mysql数据库实验答案

etnamebysno('000105',@name);Рselect @name;Р5、修改刚建立的存储过程。Р ALTER PROCEDURE SELECT_ 'Р6、删除刚建立的存储过程。РDROP PROCEDURE SELECT_WOMANР 实验八触发器的插入、删除、更新和创建Р对student表创建delete触发器,当删除某个学生记录时,同时在选课表SC中删除该学生的选课记录。Рmysql 通过Рuse student;РInsert Into Student Values('000101', '刘八', '女', 22, '信息科学系');РInsert Into SC Values('000101', '2', 91);Рselect * from student ; Рselect * from sc ; Рcreate trigger t1 AFTER delete on student Р FOR EACH ROW BEGINР Delete from SC WHERE sno = old.sno;Р END;Р Р在student表上定义了一个update触发程序,用于检查更新sage时将使用的新值,小于16时取得16,大于40时取40,并更改值。Рuse student;Рcreate trigger upd_check before update on student Р FOR EACH ROW Р beginР if new.sage<16 thenР set new.sage=16;Р elseif new.sage>60 thenР set new.sage=40;Р end if;Р end;Рselect * from student; Р update student set sage=2 where sno='000105';