Skip navigation links

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


Advanced Search

Re: MySQL Workbench – How to fetch more than 1000 Records
Posted by: Florian Nicolais ()
Date: August 24, 2010 07:40AM

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.

Options: ReplyQuote


Subject Views Written By Posted
MySQL Workbench – How to fetch more than 1000 Records 3985 Edwin DeSouza 08/19/2010 10:53PM
Re: MySQL Workbench – How to fetch more than 1000 Records 7052 Florian Nicolais 08/24/2010 07:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.