MySQL 如何让Mysql添加超过1000行？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6855705/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to allow Mysql to add more than 1000 rows?
提问by T3000
I have installed Mysql on vista and XP. I use perl to crawl the net and insert the data needed into mysql database. The problem is that once the database reaches 1000 rows, the script is not anymore able to add data into the database. is there something that I have to do to fix that problem? I expect the database to have more than 80,000 rows. Thanks for your help.
我已经在 vista 和 XP 上安装了 Mysql。我使用perl 来爬网并将需要的数据插入到mysql 数据库中。问题是一旦数据库达到 1000 行，脚本就不能再将数据添加到数据库中。有什么我必须做的来解决这个问题吗？我希望数据库有超过 80,000 行。谢谢你的帮助。
回答by DKSan
The MySQL Workbench will by default show just 1000 rows to prevent you from loading the whole table (which will require loads of time once you reach lets say 2million records).
默认情况下，MySQL 工作台将只显示 1000 行，以防止您加载整个表（一旦达到 200 万条记录，这将需要大量时间）。
On the screenshot you can see the controls which are placed directly over the resultset. If you want to display all data, just click the 7th button (Tooltip: Toggle limitation of the records number). This will show you all the records in the table.
在屏幕截图上，您可以看到直接放置在结果集上的控件。如果要显示所有数据，只需单击第 7 个按钮（工具提示：切换记录数限制）。这将显示表中的所有记录。
Now in Workbench 6.2 version Go To Query Tab --> Limit Rows --> (Tick Mark) Don't Limit
现在在 Workbench 6.2 版本中 Go To Query Tab --> Limit Rows --> (Tick Mark) Don't Limit
回答by Michael Law
.
.
Couldn't you just use something like: SELECT * FROM table LIMIT 0, 81000
你不能只使用类似的东西：SELECT * FROM table LIMIT 0, 81000
If you suspect that there are 80k records then this will return all
如果您怀疑有 80k 条记录，那么这将返回所有
.
.
回答by Richard
Sequel Pro > Preferences > Tables > Limit result to: (in this case 80,000) rows
Sequel Pro > Preferences > Tables > 将结果限制为：（在本例中为 80,000）行
