Datagrip - get row count (easily) on queries with more than 500 results

datagrip
Kristen Waite picture Kristen Waite · Feb 15, 2017 · Viewed 7.7k times · Source

Is there a way (setting or shortcut) for displaying the total row count of a query that outputs more than 500 rows - that is, without modifying the "Result set page size" value in preferences? I'm looking essentially for the output of select count(*) from (<query>) t in addition to the displayed rows.

Answer

moscas picture moscas · Feb 20, 2017

Click on page-size of the result-set

count(*) in DataGrip

Related questions

Creating new database in DataGrip JetBrains

Anybody know how to create new database in DataGrip (database IDE from JetBrains)? Could not find in DataGrip Help page.

Read More
How to Export/Import a Data Source from DataGrip?

I can't seem to figure out how to export a data source configuration in DataGrip (currently on 2016.2 EAP). I would like to export a handful of data sources and share them with my teammates to make it easier for them …

Read More
How to export a data base from DataGrip at one SQL file?

How I can export a data base from DataGrip at one SQL file as phpmyadmin export? If I use Dump Data To Files, DataGrip save one table at one file. And how I can create backup of all MySQL databases, …

Read More