MySQL Workbench is default IDE for MySQL. It can be installed on Windows, Linux or Mac OSX. Here is the one question which new users of MySQL Workbench often ask –
“When I execute my SQL Query from my application, it retrieves correct numbers of the row, but when I execute the same query in MySQL Workbench it retrieves only 1000 records. What is the reason behind it?”
This is a very valid question and here is the answer –
You can easily change this limit by going to MySQL Workbench >> Edit >> Preferences >> SQL Queries tab. Over here you will option to Limit Rows. You can set this to very high value or uncheck the option. When you uncheck that option, it will retrieve all the rows from a query (equivalent to no limits).
Let me know what is your opinion?
Reference: Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
how do infinite number of rows upload in mysql workbench