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 ;

posted @ 2018-12-05 11:14  煦色韶光  阅读(226)  评论(0编辑  收藏  举报