Is the primary key automatically indexed?

Question

Is it true that in MySQL the primary key is automatically indexed?

+6

sql mysql

l --''''''--------- '' '' '' '' '' '' ' Jun 03 '10 at 2:04

source share

1 answer

Daniel Vassallo · Accepted Answer · 2010-06-03T02:06:51+0000

Yes it's true. An index is required to provide a unique constraint on primary keys.