create trigger delete_trigger
after delete on table_delete1
for each row
begin
DELETE FROM table_delete2 WHERE column1 = old.column1;
end;
解釋:删除表 table_delete1的某行,級聯删除table_delete2的行中column1等于 table_delete1删除行column1的行。
注意,old即由table_delete1删除行組成的臨時表。insert或者update時臨時表還有new;若需要滿足條件後觸發,則在begin後面加判斷 if .. then.. end if 即可