Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: mos (mos99fastmail.fm)
Date: Thu Jul 30 2009 - 11:26:48 CDT
At 09:13 AM 7/30/2009, b wrote:
>Are UNIQUE KEY & UNIQUE INDEX two ways of specifying the same thing? If
>not, what are the differences?
>Feel free to tell me to RTFM but please post manual chapters. I've been
>looking but haven't been able to find anything.
They are the same thing. If you meant "Primary Key" and "Unique Index"
then they too are basically the same except Primary Key is NOT NULL and the
optimizer will infer the primary key when doing RI joins if an index is not
There may be other subtle differences that others can comment on.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql