批量插入数据表格

drop procedure if exists my_procedure;
delimiter //  #代码块分隔符
create procedure my_procedure()
begin
DECLARE n int DEFAULT 1;
WHILE n < 3 DO # 插入数据条数n
insert into ihq_user (name,passwd,type,status,audit_status,begin_date,end_date,activate_date,exchange,forward_room_name) values (CONCAT('tesname',n),'a123456',1,1,1,'2022-05-01','2022-09-01','2022-05-01',1,'证券技术大厦数据中心');
set n = n + 1;
END WHILE;
end
//
delimiter ;
call my_procedure();

###循环插入数据