Jorge Armas
Reputation: 11
How to make a SELECT statement show more than 1000 records in MYSQL?
Hello I would like to know How to display more than 1000 registers when I`m using a SELECT statement in MYSQL
Upvotes: 1
Views: 7174
Answers (2)
Dave Stokes
Reputation: 823
Check your configuration file for the --i-am-a-dummy option. You are not really a dummy but it keeps you from shooting yourself in the foot with things like long running queries.
Upvotes: 0
Uueerdo
Reputation: 15941
Assuming you're using MySQL Workbench...
Edit->Preferences, SQL Editor->SQL Execution Uncheck "Limit Rows", or set "Limit Rows Count" higher
Upvotes: 3
Related Questions
- How to select N records from a table in mysql
- How to select n row from table where there is 300'000 rows
- How do I guarantee that I get 1000 rows from a SELECT query? MySQL
- How can I show last 100 rows?
- MySQL select x number of records from table by column
- PHP get max. 1000 entries from MySql
- SOQL Query to fetch more than 2000 records
- need to get more than 50000 records in mysql query
- mysql select statement and limiting the number of records
- How to count up to certain number of rows e.g. if exceeds 1,000, then select count only up to 1,000?