Mysql 存储过程记录（未整理）

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