Mysql Help! UNIQUE vs INDEX difference.
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?
High Energy Magic Dept.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)