(catching up on old mail) What version of MySQL are using? It
works in 5.0.19 and 5.1.9-beta. If you're trying on a version < 5.0,
it won't work.
-Sheeri
On 4/9/06, Daevid Vincent <[EMAIL PROTECTED]> wrote:
I'm trying to follow the example in the manual to create a trigger:
http://dev.mys
I don't have a 5.0+ server to test with right now but this should work
--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> I was using SQLYog 5.03 RC1.
>
> vmware ~ # mysql --version
> mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using
> readline 5.1
>
> But just to sanity check. I ssh'
sql@lists.mysql.com
> Cc: 'Shawn Green'
> Subject: RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)
>
> I was using SQLYog 5.03 RC1.
>
> vmware ~ # mysql --version
> mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline
> 5.1
>
skey = 9;
END IF;
END' at line 5
mysql> delimiter ;
mysql>
> -Original Message-
> From: Shawn Green [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 11, 2006 12:41 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: Re: FW: New to TRIGGER and CALL. Example gi
--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> This may have been lost, so I'm reposting hoping for a clue as to why
> the
> mySQL example onlie gives me errors...
> -Original Message-
> Sent: Sunday, April 09, 2006 7:41 PM
>
> I'm trying to follow the example in the manual to create a
This may have been lost, so I'm reposting hoping for a clue as to why the
mySQL example onlie gives me errors...
-Original Message-
Sent: Sunday, April 09, 2006 7:41 PM
I'm trying to follow the example in the manual to create a trigger:
http://dev.mysql.com/doc/refman/5.0/en/using-triggers
I'm trying to follow the example in the manual to create a trigger:
http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html
#DROP TRIGGER upd_check;
delimiter //
CREATE TRIGGER upd_check BEFORE UPDATE ON starkeys
FOR EACH ROW
BEGIN
IF NEW.skey < 1 THEN
SET NEW.skey = 1;
