CREATE DEFINER=`root`@`%` PROCEDURE `myproc`()
BEGIN
DECLARE
num INT ;
SET num = 1 ;
WHILE num < 25 DO
INSERT INTO product (
product_type_id,
product_name,
product_format,
product_desc_price,
product_price,
product_picture,
business_id,
product_status,
queue
)
VALUES
(
'1',
'虎跑优质饮用水 19L',
'19L*1/桶',
'桶',
'10.00',
'/picture/water/2017052009.png',
num,
'open',
'6'
);
INSERT INTO product (
product_type_id,
product_name,
product_format,
product_desc_price,
product_price,
product_picture,
business_id,
product_status,
queue
)
VALUES
(
'1',
'千岛湖饮用水 19L',
'19L*1/桶',
'桶',
'10.00',
'/picture/water/2017052010.png',
num,
'open',
'7'
);
SET num = num + 1 ;
END
WHILE ;
END
存储过程循环添加数据到数据库中
最新推荐文章于 2024-07-19 03:25:55 发布