At times, we need a certain combination of column values to be unique in a table. With MySQL, this can be achieved using the UNIQUE keyword.
There can be a combination of one or more keys and the same will be validated before inserting the data to the table.
Example: Table named DETAILS is created as below.
CREATE TABLE 'Details' ( 'ai' INT(11) NOT NULL , 'name' VARCHAR(50) NULL DEFAULT NULL , 'address' VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_bin', UNIQUE (ai,name))COLLATE='utf8_bin'ENGINE=InnoDB;
This ensure that the values in column ai and name combined are unique in nature. This can be made for any combination of columns.