存储过程mysql批量删除记录

//创建函数

CREATE PROCEDURE DATA_SOURCE_DELETE(sourceID varchar(32),certNo varchar(32))

BEGIN
delete from t_bankcard_info where cust_id = sourceID;
delete from t_work_info where cust_id = sourceID;
delete from t_idcard_info where cust_id = sourceID;
delete from t_attachment_info where cust_id = sourceID;
delete from t_credit_flow where cust_id = sourceID;
delete from user_account_info where cert_no= certNo;
--省略其他...


END;
 

//调用函数
CALL DATA_SOURCE_DELETE('431652261546954752','510823198802131227');