56,679
社区成员
发帖
与我相关
我的任务
分享
DROP PROCEDURE IF EXISTS tripdatatest.pr_InsertTravelss;
CREATE PROCEDURE tripdatatest.`pr_InsertTravelss`(
)
BEGIN
DECLARE i INT DEFAULT 0;
DECLARE travelsID INT DEFAULT 0;
declare err int default 0;
declare continue handler for sqlexception set err = 1;
start transaction;
select max(TravelsID) as id from t_travelsinfo;
if err = 0 then
commit;
else
rollback;
end if;
END;