create trigger [trgDeleteEuser]
on [dbo].[E_UserInfo]
for delete
as
delete Job_Info from Job_Info j join Deleted d on j.user_name=d.user_name
delete job_evaluation from job_evaluation e join Deleted d on e.user_name=d.user_name在线,急等
on [dbo].[E_UserInfo]
for delete
as
delete Job_Info from Job_Info j join Deleted d on j.user_name=d.user_name
delete job_evaluation from job_evaluation e join Deleted d on e.user_name=d.user_name在线,急等
delimiter $$
create trigger trgDeleteEuser after delete on E_UserInfo
for each row
begin
delete from Job_Info where user_name= old.user_name;
delete from job_evaluation where user_name=old.user_name;
end;$$
delimiter ;