more results please!

[Quetzycoatl]

I am new to MySql and I need to make queries that yield 1200+ results but the maximum I can get at one time is 1000. I know i can refine my queries and divide the results up, but for my purposes this is rather inconvenient. Is there some setting or variable I can change to allow the return of more than 1000 results?

 

[sleipnir214]

I just went into my mysql command-line app and performed a query that returned 41581 rows.

It's likely a limit in your database client software. How are you accessing the data?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Quetzycoatl]

I am using MySQL Control Center 0.9.2-beta, which is what I was told to use by the person managing the database.

 

[sleipnir214]

There is a setting called SQL_SELECT_LIMIT, which limits the number of records return from a SELECT query. The online manual states that if you have a LIMIT clause in your query that is larger than the setting, MySQL will return the number of rows you specify.

You might just try:

SELECT .... LIMIT 10000

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Quetzycoatl]

Ack I just found it. Under edit. Thanks anyway!