CREATE PROCEDURE `create_new_product_time`(
IN name VARCHAR(500),
IN product_type_id INT,
IN deposit VARCHAR(500)
)
BEGIN
DECLARE sale_count int unsigned default 0;
DECLARE check_count int unsigned default 0;
DECLARE var INT unsigned DEFAULT 0;
DECLARE var_sale INT unsigned DEFAULT 0;
INSERT INTO `product` (
`name`
)
VALUES
(
name
);
SET @NewID=@@IDENTITY;
-
INSERT INTO `product_record` (
`
`name`
) SELECT
`name`
FROM
product
WHERE
product.id = @NewID;
INSERT INTO `product_extend` (product_id,)values(@NewID,);
call sp_split(checkers,';');
SELECT count(*) as counts into check_count from temp_key_split;
WHILE check_count > var DO
INSERT INTO `product_checker` (user_id,product_id,department,organization_id,creator_id,modifier_id,create_time,modify_time)values((select key_words from temp_key_split limit var,1 ),@NewID,'1-3-139',139,create_id,create_id,now(),now());
SET var = var + 1;
END WHILE;
IF check_method = 2 THEN
,,,,
END IF;
END
Mysql 存储过程记录(未整理)
最新推荐文章于 2022-08-23 17:11:01 发布