mysql 批量插入数据

1. DROP PROCEDURE
   
2. IF EXISTS test_data;
   
3. 
   
4. DELIMITER $
   
5. CREATE PROCEDURE test_data()
   
6. BEGIN
   
7.     DECLARE i INT UNSIGNED DEFAULT 1;
   
8.     WHILE i <= 100 DO
   
9.                   INSERT INTO sc (`s_id`,`c_id`,`score`) SELECT id,i,FLOOR((RAND() * 100)) FROM student;
   
10.         SET i = i+1;
    
11.     END WHILE;
    
12. END $
    
13. 
    
14. CALL test_data();

复制代码