MySQL-我可以在一条INSERT语句中插入几行? [英] MySQL - how many rows can I insert in one single INSERT statement?

问题描述

它是否取决于值集的数量?它是否取决于INSERT语句中的字节数?

Does it depend on the number of values sets? Does it depend on the number of bytes in the INSERT statement?

推荐答案

您可以使用INSERT ... SELECT模式插入无数记录，前提是您在其他表中有或部分记录.

You can insert infinitely large number of records using INSERT ... SELECT pattern, provided you have those records, or part of, in other tables.

但是，如果要使用INSERT ... VALUES模式对值进行硬编码，则对语句的大小/长度有限制:

But if you are hard-coding the values using INSERT ... VALUES pattern, then there is a limit on how large/long your statement is: max_allowed_packet which limits the length of SQL statements sent by the client to the database server, and it affects any types of queries and not only for INSERT statement.

这篇关于MySQL-我可以在一条INSERT语句中插入几行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！