ully obvious reasons, 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.
"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. T
rrent PL/SQL triggers, this is just the most basic example. 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
Su
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 IF
