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 ;