. I'm
getting the feeling I'm pretty rare in this situation.
Thanks,
Dan.
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 10:52 AM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Subject: Re: Trigger exception handling
snip
DECLARE EXIT HANDLER
Burke, Dan [EMAIL PROTECTED] wrote on 08/25/2005 03:42:18 PM:
I don't think this is really what I'm looking for.
What I need is to be able to perform certain validation on the data from
within the trigger. If that validation fails, then I need the trigger
to abort with an error. The
, I don't use Oracle for personal projects, so
triggers are a feature I've longed for in MySQL.
Dan.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 25, 2005 4:16 PM
To: Burke, Dan
Cc: mysql@lists.mysql.com
Subject: RE: Trigger
Dan,
See http://dev.mysql.com/doc/mysql/en/declare-handlers.html. Here's a
wee example...
USE test ;
SET @err = 0 ;
SELECT 'Before running errhandlerdemo:', @err ;
CREATE TABLE IF NOT EXISTS testhandler (i INT, PRIMARY KEY(i)) ;
SET GLOBAL log_bin_trust_routine_creators=TRUE
DROP PROCEDURE