mysql workbench records limit

I perform an SQL query on a database with MySQL and I get back only the first 1000 rows from 24000 expected. If i export the results to an XML form, I get the first 1000 again. Is there a way to disable that limit and get back all the rows? Otherwise, I will have to merge 24 XML files :/

Answers


Do these steps:

  1. Go to Edit -> Preferences.
  2. Click on the SQL Editor tab.
  3. Under Query Editor, uncheck Limit Rows.

Need Your Help

Python unittest mock … mock a module statement

python unit-testing python-2.7 mocking xbmc

I'm having difficuly getting my head around python's mock test methodology.

Initializing and using dynamic arrays in C++

c++ arrays dynamic initialization

In my code, I am trying to create a dynamic array with initArray function, and in main I would like to use this initialized array. However, whenever i called the initialized array in main, it is gi...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.