I have a table:
table votes (
id,
user,
email,
address,
primary key(id),
);
Now I want to make the columns user, email, address unique (together).
How do I do this in MySql?
Of course the example is just… an example. So please don't worry about the semantics.
Best Answer
To add a unique constraint, you need to use two components:
ALTER TABLE
- to change the table schema and,ADD UNIQUE
- to add the unique constraint.You then can define your new unique key with the format
'name'('column1', 'column2'...)
So for your particular issue, you could use this command: