开发时批量插入mysql数据库测试数据sql脚本语句

sohsyo

于 2022-12-01 10:28:33 发布

阅读量737

点赞数 1

文章标签：数据库 mysql sql

本文链接：https://blog.youkuaiyun.com/weixin_45251876/article/details/128127690

版权

delimiter $$
CREATE PROCEDURE insert_current_data_uuid(IN item INTEGER)
BEGIN
	DECLARE counter INT;
	SET counter = item;
	start transaction; -- 整个存储过程指定为一个事务
	WHILE counter >= 1 DO
		insert into reservoir_yuliang_data (position_num, channel_num,unit,total_count,receive_value,collect_time,creat_time)
		values('595', 'F1','mm', '93.0','0','2022-11-29 15:06:00','2022-11-29 15:06:00');
		SET counter = counter - 1;
	END WHILE;
	commit; -- 必须主动提交
END
$$

call insert_current_data_uuid(4500000); -- 添加次数