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?