Jump to content

Mysql problem When i'm trying to run a query i got LIMIT 0, 25


giannis196
 Share

Recommended Posts

On 10/6/2019 at 7:38 PM, giannis196 said:

Hi everyone, i am using mysql for database and when i am trying to run the query SELECT * FROM carshopdatabase i got the following error message:

SELECT * FROM carshopdatabase LIMIT 0, 25


So, why is this happening and how do i fix it?

Thanks!

Just so you know, the LIMIT keyword indicates the number of rows to output. In this case, it is including Row 0 (first row) up to (but not including) Row 25 (26th row).

Its quite common for it to be added to SQL browsers such as phpmyadmin and others. Just so if you have 70k rows (like I work with) you don't kill your program trying to look at all of them.

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...