CREATE DEFINER=`sa`@`%` TRIGGER `hospitalmanagementsystem`.`staff_AFTER_INSERT` AFTER INSERT ON `staff` FOR EACH ROW
BEGIN
declare tmp varchar(20);
set tmp=(select userrole_name from `userrole` where userrole_id=NEW.staff_sf);
insert into `login` values(NEW.staff_dh,NEW.staff_dh,NEW.staff_no,NEW.staff_name,tmp);
END
转载请注明原文地址: https://www.6miu.com/read-83617.html
