唯一索引和唯一约束可以一起设置嘛?二者有冲突嘛?

Discuss / SQL / 唯一索引和唯一约束可以一起设置嘛?二者有冲突嘛?

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

如题

#2 Created at ... [Delete] [Delete and Lock User]

唯一索引=唯一约束+索引

#3 Created at ... [Delete] [Delete and Lock User]

可以一起设置，但没必要，不会冲突，只不过是会对同一个列，设置了二次唯一约束，可以通过

 SELECT * FROM information_schema.`TABLE_CONSTRAINTS` where table_name = 'student'

查询到二个不同名字的唯一约束