A valid question.  However that's only the simplest example of the kind of 
validation I'm trying to put into the triggers (for the sake of a shorter 
email).

Dan.

-----Original Message-----
From: Björn Persson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 09, 2005 5:25 PM
To: mysql@lists.mysql.com
Subject: RE: Triggers that handle multiple events (insert and update)

onsdagen den 9 november 2005 18:07 skrev Burke, Dan:
> For example, one field has to be >= 0, so I put this validation

Why don't you just declare that field as unsigned?

Björn Persson

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to