MySQL Forums
Forum List  »  MySQL Workbench

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

Written By
Re: MySQL Workbench – How to fetch more than 1000 Records
August 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.