Home > Article > Database > MySql batch insert performance optimization

MySql batch insert performance optimization

大家讲道理Original: 2016-11-12 10:39:061200browse

INSERT INTO `insert_table` (`datetime`, `uid`, `content`, `type`) 
    VALUES (&#39;0&#39;, &#39;userid_0&#39;, &#39;content_0&#39;, 0);
INSERT INTO `insert_table` (`datetime`, `uid`, `content`, `type`) 
    VALUES (&#39;1&#39;, &#39;userid_1&#39;, &#39;content_1&#39;, 1);

changed to:

INSERT INTO `insert_table` (`datetime`, `uid`, `content`, `type`) 
    VALUES (&#39;0&#39;, &#39;userid_0&#39;, &#39;content_0&#39;, 0), (&#39;1&#39;, &#39;userid_1&#39;, &#39;content_1&#39;, 1);

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：Implementation methods of segmented query technology in major databasesNext article：Implementation methods of segmented query technology in major databases

See more

MySql batch insert performance optimization

Related articles