Okay, I have a database, and there's a table in it named "members". There's only one field in it, that is "id". id is primary and unique.
Now, I add another field "username" to "members" and it works fine.
ALTER TABLE members ADD username VARCHAR (16) not null
ALTER TABLE members ADD UNIQUE (username)
But after that, when I put this, it gives me an error "key column 'email' does not exist in table".
ALTER TABLE members ADD email VARCHAR not null
ALTER TABLE members ADD UNIQUE (email)
What really confuses me is that, when I trry to add it without making email unique, it goes through without any error messages, yet it does not add the field to my table.
Can someone tell me why?
