[thelist] mysql primary key multiple columns

Scott Dexter sgd at ti3.com
Tue Aug 29 09:48:43 CDT 2000


in mysql i dunno, you can in SQL Server, but instead of a multiple column pk
try using a multi-column unique constraint --it may be faster....

sgd
--
http://thinksafely.org

> -----Original Message-----
> From: Peter Van Dijck [mailto:peter at vardus.com]

> Can I set multiple columns as primary key in mysql so that it is the 
> COMBINATION that is unique?





More information about the thelist mailing list