CREATE DEFINER=`root`@`%` PROCEDURE `BatchInsert`()
BEGIN
#Routine body goes here...
DECLARE i int default 1;
while(i<=10000) do
INSERT INTO 表名(列1,列2,列3,列4) VALUES( '数据1', '数据2', '数据3', '数据4' );
SET i = i+1;
end while;
END
T-SQL 批量添加数据MysqlNavicat存储过程CREATE DEFINER=`root`@`%` PROCEDURE `BatchInsert`()BEGIN #Routine body goes here... DECLARE i int default 1; while(i<=10000) do INSERT INTO 表名(列1,列2,列3,列4) VALUES( '数据1', '数据2', '数据3', '数据4' ); SET