Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: help with phpmyadmin and mysql

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by siddmon
    LIMIT ,
    there's your error right there

    the correct syntax requires one or two numbers --
    Code:
    LIMIT [offset,] row_count
    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?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2009
    Posts
    2
    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

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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.......
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •