Tag Archives: unique index in mysql

unique index on a table

unique index means that two rows cannot have the same index value. unique index creates using the keyword unique. For example: Simple index: create index myindex on tablefirst(cloumn1); Unique index: create unique index myindex2 on tablesecond(column2);