贴个主键重复的错误处理参考CREATE PROCEDURE sp_add_location (in_location VARCHAR(30), in_address1 VARCHAR(30), in_address2 VARCHAR(30), zipcode VARCHAR(10), OUT out_status VARCHAR(30)) BEGIN DECLARE CONTINUE HANDLER FOR 1062 SET out_status='Duplicate Entry'; SET out_status='OK'; INSERT INTO locations(location,address1,address2,zipcode) VALUES (in_location,in_address1,in_address2,zipcode); if(out_status='Duplicate Entry') then do your work; end if; END;
(in_location VARCHAR(30),
in_address1 VARCHAR(30),
in_address2 VARCHAR(30),
zipcode VARCHAR(10),
OUT out_status VARCHAR(30))
BEGIN
DECLARE CONTINUE HANDLER FOR 1062 SET out_status='Duplicate Entry';
SET out_status='OK';
INSERT INTO locations(location,address1,address2,zipcode) VALUES (in_location,in_address1,in_address2,zipcode);
if(out_status='Duplicate Entry') then
do your work;
end if;
END;