Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Unanswered: MySQL ERROR 1064

    I have this php file that sets up a MySQL database for me using a .CSV file. I used it on one SQL database and then transfered it over to a different server. Now when i run database_setup.php 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 ') ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1 "

    The line "ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci" is the error i guess but i don't know how to find out what to change it too.

    Could anyone help me with this?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it's the dangling comma aftyer the `banner` column, just in front of the parenthesis in front of ENGINE

    how do i know this? you didn't even post your CREATE TABLE statement!!!

    i can see your query from here, using Microsoft® CrystalBall©

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

Posting Permissions

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