mysql批量插入之提高插入效率

INSERT INTO insert_table (datetime, uid, content, type)
VALUES ('0', 'userid_0', 'content_0', 0);
INSERT INTO insert_table (datetime, uid, content, type)
VALUES ('1', 'userid_1', 'content_1', 1);
修改成:

INSERT INTO insert_table (datetime, uid, content, type)
VALUES ('0', 'userid_0', 'content_0', 0), ('1', 'userid_1', 'content_1', 1);

效率瞬间提高

posted @ 2017-01-16 16:14  大麦茶fg  阅读(768)  评论(0编辑  收藏  举报