Unique constraint for two columns in Mysql and indexes

Question

Sorry for newbie question - am I understand right that these two operators are identical in Mysql?

ALTER TABLE friends ADD CONSTRAINT UNIQUE (`user_id`, `friend_id`);

and

CREATE UNIQUE INDEX friends_user_friend ON friends (user_id, friend_id);

Answer 1

yes !

only CREATE INDEX cannot be used to create a PRIMARY KEY, use ALTER TABLE instead

read more in :

http://dev.mysql.com/doc/refman/5.0/en/create-index.html

Answer 2

See this link http://stackoverflow.com/questions/388982/mysql-5-0-indexes-unique-vs-non-unique

Bye.