Re: constraining unique values across columns

2006-05-01 Thread Shawn Green
sorry :( I clicked "send" too early --- Shawn Green <[EMAIL PROTECTED]> wrote: > > > --- Scott Purcell <[EMAIL PROTECTED]> wrote: > > > I occasionally run into issues where I would like to ensure that > the > > values across two or three columns are not duplicated. At work we > use > > Oracle

Re: constraining unique values across columns

2006-05-01 Thread Shawn Green
--- Scott Purcell <[EMAIL PROTECTED]> wrote: > I occasionally run into issues where I would like to ensure that the > values across two or three columns are not duplicated. At work we use > Oracle, and I see that they add constraints when creating the > columns. I > am running mysql 5.0 and was

RE: constraining unique values across columns

2006-05-01 Thread Tim Lucia
PROTECTED] Sent: Monday, May 01, 2006 9:07 AM To: mysql@lists.mysql.com Subject: constraining unique values across columns I occasionally run into issues where I would like to ensure that the values across two or three columns are not duplicated. At work we use Oracle, and I see that they add

constraining unique values across columns

2006-05-01 Thread Scott Purcell
I occasionally run into issues where I would like to ensure that the values across two or three columns are not duplicated. At work we use Oracle, and I see that they add constraints when creating the columns. I am running mysql 5.0 and was hoping someone could give me the simple explanation of how