MySQL5.7 批量写入数据

• MySQL5.7批量写入数据

MySQL5.7批量写入数据

# 一、创建存储过程
CREATE PROCEDURE p02() BEGIN
	DECLARE
		i INT;
	
	SET i = 0;
	WHILE
			i <= 2000 DO
			INSERT INTO xxx.xxx ( x, x, x, x, x, x )
		VALUES
			( CONCAT( '字符串', i ), 1, '6', '6', '6', 6 );
		
		SET i = i + 1;
		
	END WHILE;

END;


# 呼叫存储过程
call p02();


# 移除存储过程
drop PROCEDURE p01;