mysql使用存储过程，批量生成测试数据

1.存储过程代码

delimiter $$
DROP PROCEDURE IF EXISTS create_service_data$$
create procedure create_service_data(size INT)

begin
START TRANSACTION;
SET @id=0;
WHILE @id<size DO
SET @bid='1000008';
SET @serviceId=@id+1;
SET @accountType=1;
SET @perTradingVolume = FLOOR(RAND() * 100000);
SET @orderTotalPrice = FLOOR(RAND() * 100000);
SET @avgOrderTotalPrice = 90000;
SET @customerNum = FLOOR(RAND() * 100000);
SET @avgCustomerNum = 90000;
SET @payRate = FLOOR(RAND() * 100);
SET @detailPageUvNum = FLOOR(RAND() * 100000);
SET @avgDetailPageUvNum = 90000;
SET @initServiceScore = 0;
SET @createDate = 20180803;
INSERT INTO test.testInsert(id, bid,serviceId,accountType,perTradingVolume,orderTotalPrice,avgOrderTotalPrice,customerNum,avgCustomerNum,payRate,detailPageUvNum,avgDetailPageUvNum,initServiceScore,createDate)
VALUES(null,@bid,@serviceId,@accountType,@perTradingVolume,@orderTotalPrice,@avgOrderTotalPrice,@customerNum,@avgCustomerNum,@payRate,@detailPageUvNum,@avgDetailPageUvNum,@initServiceScore,@createDate);
SET @id=@id+1;
end while ;
COMMIT;
end$$
delimiter ;

2.查看存储过程

（1）查看所有已经建立的存储过程列表

　　show procedure status;

（2）查看某个存储过程详情

　　show create procedure 存储过程名称;

巴特西

mysql使用存储过程，批量生成测试数据

最新文章

热门文章