在Navicat上连接MySQL,用while循环10次插入数据的语句
delimiter ;; #一定要加上,否则不能识别程序
drop procedure if exists test_insert; #判断删除已存在的程序
CREATE PROCEDURE test_insert () #创建程序
BEGIN
DECLARE i INT DEFAULT 0;
WHILE i<10 DO
insert into data_10KW (serial_number,xx,xxx) select serial_number,xx,xxx from data_1000W;
set i=i+1;
END WHILE;
COMMIT;
END;;
CALL test_insert();