i create a database in mysql and when im trying to browse the content i get this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
SELECT *
FROM `example`
LIMIT ,


i get this error in all the tables that i have created before.

if someone knows how to solve, please post the solution

Thanks in advance

there's your error right there

the correct syntax requires one or two numbers --so, for example, you could have LIMIT 4 to return 4 rows, or LIMIT 9,37 to return 37 rows after skipping 9

but LIMIT , is invalid syntax

get it?

thaks for your answer

but how i can solve that

i'm not writing the query, when i click in the browse of the table to view the content, phpmyadmin create that query and show the error

so write your query to do waht you want

because you are using PhPMyAdmin you are havinbg problems

to start with try select * from mytable
..or wahtever your table is called
try using a query tools such as heidi SQL, or MySQL Query browser (available form MySQL as a free download

if i remember correctly on the PHPMyAdmin table admin page there is a box which allows you to limit the number of records..set the value to say 999999 ad see what happens, or set it to 25.......