Jump to content
giannis196

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

Recommended Posts

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!

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...