Mysql 涉及事务的存储过程

BEGIN
	#Routine body goes here...
DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;
START TRANSACTION;
savepoint sp;
begin
DECLARE IDLog INT;
INSERT INTO ProcExecLog(ProcName) VALUES('Ppjid_WeeklyInsert');

end;
if @@error_count=0 THEN
	commit;
else
	ROLLBACK to savepoint sp;
end if;
END