mysql居然只能在存儲(chǔ)過(guò)程中使用declare定義變量，DECLARE CONTINUE HANDLER FOR SQLEXCEPTION也只能在存儲(chǔ)過(guò)程中用？
begin TRANSACTION
SET XACT_ABORT on --sql異常事物自動(dòng)回歸
--mysql中等價(jià)的語(yǔ)句: declare continue handler for sqlexception begin rollback; end;
--0 金幣
IF(1 = @ItemId)
BEGIN
update QPTreasureDB.dbo.GameScoreInfo SET Score = Score + @ItemCount WHERE UserID = @UserId;
END
--test
INSERT INTO QPAccountsDB.dbo.AccountsInfo(UserId) VALUES(1);
COMMIT TRANSACTION
CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_Test`()
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
SELECT 'SQLEXCEPTION handler was activated' AS msg;
BEGIN -- inner block
DECLARE CONTINUE HANDLER FOR SQLSTATE '42S02'
SELECT 'SQLSTATE handler was activated' AS msg;
END;
select * from test_table;
END