mysql - 导出数据库时 'Maximal length of created query' 是什么

Question

我正在使用 phpMyAdmin我想从数据库中导出所有数据。 “创建查询的最大长度”属性是否会影响您导出的数据量？

Answer 1

不，它没有。它确实会在一定程度上影响导出文件的大小。唯一发生的事情是它限制了每个 INSERT 语句插入的行数。所以你最终会得到更多、更小的语句。

Here来自他们 wiki 的一些信息:

The option 'Maximal length of created query' seems to be undocumented. But experiments has shown that it splits large extended INSERTS so each one is no bigger than the given number of bytes (or characters?). Thus when importing the file, for large tables you avoid the error "Got a packet bigger than 'max_allowed_packet' bytes". See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html