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]