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.

umm are you trying to call a field a number? you need to use textual fieldnames like name, id, count etc.

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