返回多个值一个有参考价值的mysql存储过程

最新推荐文章于 2021-02-08 05:50:04 发布

wwyyxx26

最新推荐文章于 2021-02-08 05:50:04 发布

阅读量255

点赞数

本文链接：https://blog.csdn.net/wwyyxx26/article/details/89145542

版权

DROP PROCEDURE IF EXISTS add_play_item;
DELIMITER //
CREATE PROCEDURE add_play_item(IN arg_PlayPlanUuid varchar(64), IN arg_PlayType varchar(64), IN arg_FileUuid varchar(64), IN arg_Duration int(10), OUT arg_ItemUuid varchar(48), OUT arg_Order int(10))
BEGIN
           DECLARE uuid CHAR(64);
           SET uuid = UUID();
           START transaction;
           INSERT INTO NPS_PLAY_ITEM_INFO(`ItemUuid`, `PlayPlanUuid`, `PlayType`, `FileUuid`, `Duration`, `Order`) VALUES (uuid,arg_PlayPlanUuid,arg_PlayType,arg_FileUuid,arg_Duration, SELECT CNT FROM (SELECT COUNT(*) AS CNT FROM NPS_PLAY_ITEM_INFO WHERE PlayPlanUuid=arg_PlayPlanUuid) A);
           SELECT `ItemUuid`, `Order` INTO @arg_ItemUuid, @arg_Order FROM NPS_PLAY_ITEM_INFO WHERE ItemUuid=uuid;
           SELECT @arg_ItemUuid, @arg_Order;
           COMMIT;
END//
DELIMITER ;