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, 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 to create constraints, and whether indexes' are > > needed for these or not. > > > > > > > > I have tried reading the docs in this regard, but because I do not > > understand the concept I am having trouble translating to the > actual > > creation of these. > > > > > > > > Thanks, > > > > Scott > > > > > > Hi Scott, > > What you want to do is called a CHECK CONSTRAINT and is not yet part > of > MySQL. However, now that MySQL has STORED PROCEDURES and FUNCTIONS > it > should be a matter of a revision or two before CHECK CONSTRAINTS are part of the mix. Until then, you will have to validate your data in your application. Shawn Green __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
