自己写的存储过程要记住二：（一个删了好多表的存储过程）

参数IN UID VARCHAR(22)

BEGIN

#公司id
DECLARE cid VARCHAR(1000);
#简历id
  DECLARE rid VARCHAR(1000);


SELECT id INTO rid FROM r_resume where USER_ID=UID;
SELECT company_id INTO cid from u_user WHERE ID=UID;
START TRANSACTION;
#删除简历详情
DELETE FROM r_resume_data WHERE resume_id=rid;
#删除简历
DELETE FROM r_resume WHERE USER_ID=UID;
#删除公司发布职位
DELETE FROM r_recruitment WHERE company_id=cid;
#删除自定义标签
DELETE FROM i_prop_ref WHERE belong_id=cid;
#删除公司
DELETE FROM u_company WHERE ID=cid;
#删除用户
DELETE FROM u_user WHERE ID=UID;
COMMIT;
SELECT cid;
SELECT rid;
END