Why don't you try it yourself. You could have tried it in less time than it took to mail the question. The manual works too.
I'm not going to answer because you need to learn how to learn.
Noel Wade wrote:
I know its possible to use multiple fields for the primary key in a table i.e. "primary key(foo,bar)"
Is it possible to do this with "unique" identifiers as well? Like "unique key(foo,bar)" ??
I already have a primary key on a table, but I'd also like to force two fields to form a unique combination (no two records should have the same foo & bar values).
Thanks!
--Noel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
