Re: MySQL Workbench – How to fetch more than 1000 Records

[Florian Nicolais]

Thanks Edwin for the article, it was exactly the problem I have (I'm switching from MySQL Administrator to MySQL Workbench).

If we keep the limit of 1000, 10000 ... records, is it possible to go to the next 1000 records without writing a "LIMIT 1000,1000" on every query (which is impossible in edit mode) ?
If not, can it be a RFE for a next version ?

My need : I have sometimes to edit some records (a date wrong for example) on a table, on records inserted with a script. With MySQL Administrator, I just click on "Edit Table Data", go to the record, click on edit, change the record, and apply changes.
If we only have 1000 records fetched and some are not on these 1000, we cannot go (unless de-activating the fetching limit) to the next 1000.
I like the fetching limit, if I can keep it it will be great.

I'm using MySQL WB 5.2.26 CE, the SQL Editor part, on Windows XP SP3.

Thanks in advance.



Edited 1 time(s). Last edit at 08/24/2010 08:35AM by Florian Nicolais.