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

[giannis196]

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!

[giannis196]

Ok guys i found it!

i should put my query between ``

SELECT * FROM `carshopdatabase ` is the correct query!

[Funce]

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.