MYSQL通过循环向数据库中插入数据

BEGIN
declare i int default 305;
declare a char(255);
REPEAT
set a=concat("测试机构00",cast(i as char));
insert into sys_organization values
(i,266,"0,266,",a,0);
set i=i+1;
until i>=344 end REPEAT;
END

posted @ 2019-07-04 13:47  萱娃  阅读(5025)  评论(0编辑  收藏  举报