mysqlCreate unique key on multiple columns
ALTER TABLE table ADD UNIQUE index1(column1, column2, column3);ctrl + ctabletable to add unique index to | ADD UNIQUEadds unique key (index) |
index1name of unique key | column1, column2, column3list of columns to create unique index on |
Related
More of Mysql
- How to find my.cnf config file
- Insert new values only if row doesn't exist already
- Get largest tables list
- What is the MEDIUMTEXT column max size (length) in Mysql
- Export table or query into CSV
- Replace string with regex
- Rename database
- Reset autoincrement for a table
- Select first record from group
- Create innodb tables dump without locking tables
See more codes...