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
- Get largest tables list
- How to find duplicate varchar/text column values in table
- Make a pager (limit / offset) select query
- Truncate all tables in a specific database
- Insert new values only if row doesn't exist already
- What is the MEDIUMTEXT column max size (length) in Mysql
- How to duplicate table structure and data
- Get server version
- Export table or query into CSV
See more codes...