Automatically delete records in child table when delete related record in parent table using mysql trigger

delimiter //
drop trigger if exists ad_question_bank//
create trigger ad_question_bank after delete on mcq_bank_master
for each row
begin

 delete from mcq_bank_details where question_id=old.id;

end;//
delimiter ;