Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Default limit for SQL queries - revamped

maeeh's profile image maeeh posted 2 months ago in General Permalink

Hi all and a happy new year.

Currently it seems that the row limit for queries can be set within the prefs to some number.

Would it be possible to add an (maybe configurable) pull-down menu to the data view screen letting the user choose on how many rows he/she wants to limit the current and all subsequent queries.

Would make it much easier, as usually f.e. i am fine with the standard 1000 cap, but sometimes need to get the full set (for export). Instead of clicking all the time on show all

ansgar's profile image ansgar posted 2 months ago Permalink

Nice idea, something like that:

Description

maeeh's profile image maeeh posted 2 months ago Permalink

YEAH, you nailed it :)

maeeh's profile image maeeh posted 2 months ago Permalink

But maybe with the option to "shpw all" at the bottom ;)

maeeh's profile image maeeh posted 2 months ago Permalink

But maybe with the option to "show all" at the bottom ;) And a section in the prefs to setup the limits (maybe 5 of them)

ansgar's profile image ansgar posted 2 months ago Permalink

You should file a feature request for that.

farinafathima's profile image farinafathima posted 2 months ago Permalink

You should file a feature request for that

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.