CREATE PROCEDURE p2()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SELECT 'Error Code : 1064,primary violation';
INSERT INTO t4 SELECT i.apply_id FROM bms_trans_info i;
select 'haha';
END
$$
This is a simple procedure.i want to complete this thing:
if insert operation fails,i want to show the message that system give,and the operations followed continue.
so what is your suggestion?