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();