That's what I thought. Thanks!
On 30. Sep 2007, at 14:55, Rob Wultsch wrote:
CHECK CONSTRAINT I mean...
On 9/29/07, Rob Wultsch <[EMAIL PROTECTED]> wrote:
CONSTRAINT does not exist in mysql.
You can use a trigger to deal with the issue, which is obviously less
than ideal.
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/mysql?
[EMAIL PROTECTED]
--
Rob Wultsch
(480)223-2566
[EMAIL PROTECTED] (email/google im)
wultsch (aim)
[EMAIL PROTECTED] (msn)
--
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]
