Obey
You just played yourself.
- Nov 23, 2013
- 250
- 29
DISCLAIMER: THIS IS MY FIRST TIME TRYING TO USE MYSQL/PHP!
Hi, I'm trying to add a column called 'country' to my 'users' table so that it's stored in the database and I can use it later on in an online users page. I thought the following SQL would work:
Code:
ALTER TABLE users
ADD column_name country
"#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 'country' at line 2"
I'm sure this is pretty simple but I just can't figure it out. Can anyone please help? Thank you.