Scribd
Upload
11 views1 page

MySQL Triggers for Employee Management

Uploaded by

pachputedhiraj14
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
11 views1 page

MySQL Triggers for Employee Management

Uploaded by

pachputedhiraj14
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Create Trigger t1 after delete on wpdemo.

employee
for each row
begin
Delete from project where empid=[Link];
end$

Delete from employee where empid=5$

eg2.
Create trigger t2 after insert on [Link]
for each row
begin
insert into project values ([Link],NULL);
end$

Insert into employee values (6,'xyz',20000)$

Create table empnames (empid int , oldname text, newname text, change_date date)$

eg.
Create trigger t3 after update on [Link]
for each row
begin
insert into empnames values ([Link],[Link],[Link],curdate());
end$

Update employee set name='keerti' where empid=1$

create trigger t4 after delete on [Link]


for each row
begin
delete from project where empid=[Link];
end$

delete from employee where empid=2$

You might also like