useful-qry/function-in-db/triggers/member_before_delete.sql

drop trigger if exists member_before_delete;
DELIMITER // 
create trigger member_before_delete before delete on pro_member
    for each row begin
        delete from pro_member_ext where id = old.id;
    end//
DELIMITER ;