Results 1 to 3 of 3
  1. #1

    Phpmyadmin problem

    I'm just trying to create a simple table in a database I just created. I keep getting an error every time as follows:

    #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 '(1) NOT NULL, `2` TINYINT(4) NOT NULL, PRIMARY KEY (`1`))' at l

    I was following a simple tutorial step by step and when I got to this part it just doesn't work. I'm doing everything exactly as described so I'm wondering what the possible errors could be and whether it is me or if it is my hoster.

    Any suggestions or alternative ideas are welcome.

    Thank you.

  2. #2
    Join Date
    Jan 2003
    umm are you trying to call a field a number? you need to use textual fieldnames like name, id, count etc.

  3. #3
    Join Date
    Dec 2002
    NY, NY
    post your full sql query here...
    i think your error is "`2` TINYINT(4)"
    what are you trying to do?
    You cant name a field "2"
    it needs a text name.
    Read the mysql manual for reserved words and special characters

Posting Permissions

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