mysql 大量插入数据_MySQL
- WBOYOriginal
- 2016-06-01 13:11:04790browse
1, 后台运行
ignore_user_abort();
set_time_limit(5*60);
2. 分组提交
TRUNCATE TABLE t_integer;
INSERT t_integer (test_id, test_value)VALUES (1, 1234),
(2, 1234),
(3, 1234),
(4, 1234),
(5, 1234),
(6, 1234),
... ...
(9997, 1234),
(9998, 1234),
(9999, 1234),
(10000, 1234);
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：ubuntu14下搭建mysql主从服务器_MySQLNext article：Windows 下MySql5.6安装教程_MySQL