当前位置：网站首页>MySQL uses stored procedures to add data

MySQL uses stored procedures to add data

2022-04-22 13:19:00 【Celestial body_】


DELIMITER $$
# Create a stored procedure    name tt
CREATE PROCEDURE tt()
BEGIN
# Define a int  Variable  i
DECLARE i INT;
# to i assignment 
SET i=1;
# The loop condition 
WHILE i<500 DO
# Add sentences 
 INSERT INTO `zx`.`vip` (`vname`,`vdate`,`card_item_id`,`stored_value_pirce`,`stored_value_consume`,`stored_value_sum`,`amount_of_product`, `product_consumption`,`product_information`, `debt`,`remark`, `vid`, `consume`,`vshop`,`stamptemp`) VALUES  ( 'vname',NOW() ,'fcc6ecab-bfde-11ec-836e-98fa9b223a51',i, i, i, i, i,i,i,'remark', UUID(),'1','vshop','stamptemp' ) ;
# Each cycle i+1
  SET i=i+1;
# end 
END WHILE;
END;
$$
# Calling stored procedure 
CALL tt();
# Delete stored procedure 
DROP PROCEDURE  tt;

版权声明
本文为[Celestial body_]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204221306583601.html

当前位置：网站首页>MySQL uses stored procedures to add data

MySQL uses stored procedures to add data

边栏推荐

猜你喜欢

随机推荐