mysql 循环插入

最新推荐文章于 2024-07-19 03:25:55 发布

原创最新推荐文章于 2024-07-19 03:25:55 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

-- 插入语句
INSERT INTO energy.water_meter_data
VALUES(NULL,'60',234,12,2,12,
'12小时','12小时',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'501','','','',
'','','','',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'张三',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),'张三')

-- 存储过程
CREATE DEFINER=`root`@`%` PROCEDURE `per2`()
begin
declare num int; 
set num=1; 
while num < 1000 do 
insert into energy.water_meter_data
VALUES(NULL,'60',234,12,2,12,
'12小时','12小时',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'501','','','',
'','','','',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),
'张三',str_to_date('2016-01-02','%Y-%m-%d %H:%i:%s'),'张三');
set num=num+1;
end while;
end

调用存储过程

call per2()