2019-06-28 mysql 循环执行sql

//定义结束符
delimiter $$
//如果已经有pre函数则删除
drop procedure  if exists pre; 
//创建pre函数
CREATE PROCEDURE pre ( ) BEGIN
//定义i
	DECLARE
		i INT;
	//起始值
	SET i = 1000;
	WHILE
            //循环
			i < 1095 DO
			INSERT INTO aa ( conn_id, invoice_type, invoice_type_name, invouce_max_amount, invoice_max_num, valid_num, used_num, lave_num, virtual_num, min_num, invoice_status )
		VALUES
			( i, '1', '机动车销售统一发票', '999999.99', '100', '100', '0', '100', '100', '5', '1' );
		INSERT t_invoice_stock_detail ( conn_id, invoice_type, invoice_type_name, invouce_max_amount, invoice_max_num, valid_num, used_num, lave_num, virtual_num, min_num, invoice_status )
		VALUES
			( i, '2', '增值税专用发票', '999999.99', '100', '100', '0', '100', '100', '5', '1' );
		INSERT t_invoice_stock_detail ( conn_id, invoice_type, invoice_type_name, invouce_max_amount, invoice_max_num, valid_num, used_num, lave_num, virtual_num, min_num, invoice_status )
		VALUES
			( i, '3', '增值税普通发票', '999999.99', '100', '100', '0', '100', '100', '5', '1' );
		INSERT t_invoice_stock_detail ( conn_id, invoice_type, invoice_type_name, invouce_max_amount, invoice_max_num, valid_num, used_num, lave_num, virtual_num, min_num, invoice_status )
		VALUES
			( i, '4', '增值税电子普通发票', '999999.99', '100', '100', '0', '100', '100', '5', '1' );
		INSERT t_invoice_stock_detail ( conn_id, invoice_type, invoice_type_name, invouce_max_amount, invoice_max_num, valid_num, used_num, lave_num, virtual_num, min_num, invoice_status )
		VALUES
			( i, '6', '二手车统一发票', '999999.99', '100', '100', '0', '100', '100', '5', '1' );
		
		SET i = i + 1;
		
	END WHILE;

END $$ CALL pre ( ); // 结束

DROP PROCEDURE idata;

delimiter;;
CREATE PROCEDURE idata ( ) BEGIN
	DECLARE
		i INT;
	
	SET i = 1;
	WHILE
			( i <= 800000 ) DO
			INSERT INTO t2 ( q, w, e, r, f )
		VALUES
			( i, i, i, i, i );
		
		SET i = i + 1;
		
	END WHILE;
	
END;;

delimiter;
CALL idata ( );