class表
ID NAME PARENT
1 FIRSTCLASS 0
2 SECONDCLASS 1
3 THIRDCLASS 2product
ID NAME SORT
1 PRO 3pro的目录结构是FIRSTCLASS-SECONDCLASS-THIRDCLASS-PRO.
如何写个触发器,删除FIRSTCLASS这条记录的时候,同时删除与其相关的所有信息?
ID NAME PARENT
1 FIRSTCLASS 0
2 SECONDCLASS 1
3 THIRDCLASS 2product
ID NAME SORT
1 PRO 3pro的目录结构是FIRSTCLASS-SECONDCLASS-THIRDCLASS-PRO.
如何写个触发器,删除FIRSTCLASS这条记录的时候,同时删除与其相关的所有信息?
delete form product where.
elseif old_name = '...' then
...
end if;