I am sorry for sending multiple notes. The reply to is set not being set to mysql discussion list. I click the reply button automatically. This email is for the sake of the list sake...
You want a feature like a check constraint: http://www.postgresql.org/docs/8.1/static/ddl-constraints.html which does exist in mysql. A trigger can be used to replicate this feature, in a less than ideal manner... On 9/29/07, David Zentgraf <[EMAIL PROTECTED]> wrote: > Hi, > > Is it possible to restrict Inserts and Updates to meet certain > conditions? > In one of my tables lets say field A, B and C can be NULL, but not > all at once. Depending on what type of item I want to store, A needs > to be NULL, but B and C need values, for other types A needs a value > but B and C can be NULL etc. > Is it possible to implement this checking logic on the database level > via CONSTRAINTs or something similar? > > Best Regards, > Dav > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Rob Wultsch (480)223-2566 [EMAIL PROTECTED] (email/google im) wultsch (aim) [EMAIL PROTECTED] (msn) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
