RE: Triggers that handle multiple events (insert and update)

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

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.my

RE: Triggers that handle multiple events (insert and update)

o:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 9:59 AM To: Burke, Dan Cc: mysql@lists.mysql.com Subject: Re: Triggers that handle multiple events (insert and update) "Burke, Dan" <[EMAIL PROTECTED]> wrote on 11/09/2005 09:05:50 AM: > Hello, > > Can triggers in 5.0 h

Re: Triggers that handle multiple events (insert and update)

"Burke, Dan" <[EMAIL PROTECTED]> wrote on 11/09/2005 09:05:50 AM: > Hello, > > Can triggers in 5.0 handle multiple events? I have some range checking > I'd like to enforce at the database level when inserting or updating a > record, and I'm finding myself duplicating trigger code to make an > IN