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!
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!
ok i just found it! i should run my query between `` so,
SELECT * FROM `carshopdatabase`
is correct!
If you want to select not all objects of your database you can use LIMIT:
“SELECT * FROM carshopdatabase LIMIT 10” (selects objects from 0 to 10) or “SELECT * FROM carshopdatabase LIMIT 20, 30” (selects objects from 20 to 30)