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.
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