MySql插入点数据


DROP PROCEDURE IF EXISTS pre;
delimiter $$


CREATE PROCEDURE pre ()
BEGIN

DECLARE i INT DEFAULT 1 ;
WHILE i <= 11 DO
INSERT INTO t_virtual_prize_details (
id_1,

id_2
)
VALUES
(
v_1,

v_2
) ;
SET i = i + 1 ;
END
WHILE ; end$$

CALL pre () ;
DROP PROCEDURE IF EXISTS pre ;