How to allow Mysql to add more than 1000 rows?

Question

I installed Mysql on Vista and XP. I use perl to traverse the network and insert the data needed into the mysql database. The problem is that as soon as the database reaches 1000 rows, the script can no longer add data to the database. is there something i have to do to fix this problem? I expect the database will have over 80,000 rows. Thank you for your help.

Answer 1

In MySQL Workbench, by default, only 1000 rows will be displayed so that you cannot load the entire table (which will take a lot of time as soon as you reach, say, 2 million records).

In the screenshot, you can see the controls that are placed directly above the result set. If you want to display all the data, just press the 7th button (hint: switching the record number limit). This will show you all the entries in the table.

Now in version Workbench 6.2 Go To Query Tab → Limit Rows → (check the box) Do not limit

Answer 2

.

Could you just use something like: SELECT * FROM table LIMIT 0, 81000

If you suspect there are 80k entries then this will return everything

.

Answer 3

Sequel Pro> Preferences> Tables> Limit the result: (in this case 80,000) rows