回答編集履歴
1
fix
test
CHANGED
|
@@ -31,14 +31,14 @@
|
|
|
31
31
|
END LOOP loop1;
|
|
32
32
|
END;;
|
|
33
33
|
DELIMITER ;
|
|
34
|
-
TRUNCATE user; CALL bulk_insert(100000, 1000);
|
|
34
|
+
TRUNCATE user; CALL bulk_insert(10000000, 1000);
|
|
35
35
|
|
|
36
36
|
SELECT count(*) FROM user;
|
|
37
37
|
SELECT * FROM user LIMIT 10;
|
|
38
38
|
```
|
|
39
39
|
|
|
40
40
|
```sql
|
|
41
|
-
mysql> TRUNCATE user; CALL
|
|
41
|
+
mysql> TRUNCATE user; CALL bulk_insert(10000000, 1000);
|
|
42
42
|
|
|
43
43
|
Query OK, 0 rows affected (3 min 23.23 sec)
|
|
44
44
|
|