[delete] 개인정보 모든테이블 삭제

<delete id="deleteMyInfo">

{call

declare

begin

DELETE FROM TABLE1 WHERE TABLE1 IN (SELECT TABLE1_NUM FROM TABLE1 WHERE MEM_ID = #{memId});

DELETE FROM TABLE2 WHERE TABLE2 IN (SELECT TABLE2_NUM FROM TABLE2 WHERE MEM_ID = #{memId});

DELETE FROM TABLE3 WHERE MEM_ID = #{memId};

end

</delete>