Mysql Help! UNIQUE vs INDEX difference.

[Paul_help_]

Hi guys.

I just have a simple question in regards to creating UNIQUE and INDEX columns in mysql.

I understand what 'UNIQUE and INDEX' do and what their differences are,, but the only thing I am not sure of is whether 'INDEX' can be used for multiple columns like 'UNIQUE' can?

Paul.

[NogDog]

Yes. UNIQUE is really just a specific type of INDEX.

Primary keys can also be across multiple columns -- they're basically a special case of a unique index.