mysql.com
Subject: RE: Trigger exception handling
> insert into accounts (ACCOUNT_NUM) values ('123 456');
> ... insert should fail in this instance, irrespective of any other
> constraints like not-null/unique fields, etc.
>
No, what you want to do isn't "rare&q
"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
Hello,
I've been looking into converting our existing Oracle PL/SQL code to mysql. A
lot of the syntax is pretty straight forward, and really doesn't require much
change from what I've been testing with thus far. However, I'm trying to
handle exceptions, and I cannot seem to find any docume
