开发需要,需要批量插入数据配合测试,记录一下,方便以后查找,也方便小伙伴搜索
DELIMITER $$
USE `库名`$$
DROP PROCEDURE IF EXISTS `proc_lottery`$$
CREATE DEFINER=`username`@`%` PROCEDURE `proc_lottery`()
BEGIN
DECLARE `shop_id` bigint(20) ;
DECLARE created TIMESTAMP;
DECLARE tel_body VARCHAR(40);
DECLARE `contacts` varchar(32);
DECLARE i INT DEFAULT 1000;
-- 调试过程, 先插入N条数据
WHILE i <= 1200 DO
SET shop_id = CONCAT(100,i);
SET created = NOW();
SET tel_body = FLOOR(RAND()*100000000);
-- tel = 159开头随机号码,但是可能出现长度不一致情况,我直接拼接写死的
SET contacts = CONCAT('159', tel_body);
SET contacts = CONCAT(15900000000, tel_body);
INSERT INTO `shop_order_lottery`
( `shop_id`, `source`, `contacts`, `lucky_times`, `unused_lucky_times`, `created`, `enabled_status`)
VALUES(
shop_id,
'appkey',
15900000000 + i ,
3,
3,
created,1
);
SET i=i+1;
END WHILE;
END$$
-- 调用存过
call proc_lottery();
-- 查询结果
select * from shop_order_lottery;