Mysql插入多条数据
DROP PROCEDURE IF EXISTS test_loop;DELIMITER //CREATE PROCEDURE test_loop()BEGINDECLARE i INT DEFAULT 1;WHILE i<1000DOINSERT INTO 表名 (ROLE_ID,MENU_ID) VALUES(i,i+1);SET i=i+1;END WHILE;CO...
