Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Retrieve Data select top x rows

Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).

I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).

2 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
William Buchanan shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Dear User,

    Thanks for your comment!

    We've added an option for selecting the top specified number of rows. You can locate it in the main menu under Tools ==> Options ==> Data Explorer ==> General ==> Preferred Selections Size. Subsequently, you'll find the 'Select Top '_' Rows' option in the context menu when right-clicking.

    Best,
    Devart Support Team

  • Loogle commented  ·   ·  Report

    Of cause. It's the default feature in dbForge Studio for MySQL.
    Please find it in: Tools menu -> Option -> Data Editor -> General, check the "Use paginal mode by default".