Geek Answers Handbook

See Length (number) of query results in workbench

I just started using MySQL Workbench (6.1). The default limit for queries is 1000 and that I want to keep this.

But the results of the action output message will always say "1000 rows returned."

Is there a parameter for viewing the number of records that will be returned in the request if there were no limit? To verify the results of a health check?

+4
source share
3 answers

The result is not always "1000 rows returned." If the number of entries is less, you will receive an actual invoice. If you want to know the total number of rows in the table, do it select count(*) from table. In addition, you can turn off the automatic limit and get all the records returned by the MySQL Workbench, but it can be the time + memory consumed for large tables.

0
source

I think removing the line limit will help. By default, the MySQL runtime limits the result set to 1000 rows, but you can always disable the limit. Check out https://superuser.com/questions/240291/how-to-remove-1000-row-limit-in-mysql-workbench-queries on how to do this.

+1
source

, , , , , SQL Server. SQL Server , , . , , , . , , desc . , .

0

More articles:


All Articles