I want a trigger to DELETE from 2 tables in MySQL -

i have 3 mysql tables (food, apple, , orange).

i want delete rows from:

apple(idapple, iduser, name)  orange(idornge, iduser, name) 

when deleting row in food(iduser, name) using 1 trigger?

here trigger far:

  create trigger `food_before_delete`      after delete on `food`      each row         delete apple, orange               apple.iduser=old.iduser ,        orange.iduser=old.iduser 

but won't compile. how can make trigger deletes 2 tables @ once?

delete 2 tables @ once trigger:

triggers used enforce data integrity in tables. can use triggers delete number of tables @ once.

before initializing triggers change mysql delimiter operator temporarily because triggers use semicolon ; operator specify multiple sql commands within trigger.

step 1 change delimiter:

delimiter $$ 

step 2 create trigger:

create trigger `blog_before_delete`        after delete on `blog`        each row      begin   delete blog_tags blogid = old.id;   delete blog_comments blogid = old.id; end $$ 

step 3 restore delimiter:

delimiter ; 

explanation:

old builtin keyword , refers blog table row deleting. mysql runs trigger blog_before_delete whenever delete entry in blog table. trigger fails, delete rolled back. helps ensure atomicity, consistency, isolation, , durability in our database.