MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 
Home / Indexes / Unique Key or Index

Like a primary index, a unique index does not permit to insert duplicate values into the respective field(s). However, the difference between primary index and unique index is that only one primary index is allowed per table, whereas multiple unique indexes are permitted. So all values in the indexed column(s) must occur once.

MySQL allows to designate multiple columns as unique in a given table. These indexes are the same as "Non-Unique" or "Normal" indexes with a restraint 'uniqueness in records'. To create unique index is simple as to create other MySQL indexes like non-unique or normal and primary index.

Unique Key or Index Related FAQs

How-to-create-unique-key-or-index-in-MySQL How to create unique key or index in MySQL?

How-to-create-multi-column-unique-key-or-index-in-MySQL How to create multi column unique key or index in MySQL?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.