How to create MySql delete trigger

Question

I have created 3 tables.

create table Employees 
( eid integer, ename char(20),age integer,salary real);

create table Departments 
(did integer,dname char(20));

create table Works 
(eid integer,did integer);

The Works.eid is a foreign key referencing Employees.eid, and the Works.did is a foreign key referencing Departments.did

I now need to create two triggers listening to the delete event on the Employees and Departments respectively, and after a deletion on the Employees table or the Departments table, the deleted employee or department should also get deleted from the Works table.

Im a Noob, any help apreeciated.

Uueerdo · Accepted Answer · 2015-12-04 18:22:29Z

1

Just use ON DELETE CASCADE when defining the foreign keys.

http://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html

answered Dec 4, 2015 at 18:22

Uueerdo

16k1 gold badge19 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create MySql delete trigger

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related