List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:December 20 2010 11:25pm
Subject:Re: Trigger?
View as plain text  
The expression you supplied looks right enough..  how was it declared?
 as an on UPDATE/on INSERT trigger or just a single case?


 - michael dykman

On Mon, Dec 20, 2010 at 5:21 PM, Jerry Schwartz <jerry@stripped> wrote:
> I've never used a trigger before, and I want to make one that sounds like it
> should be simple.
>
> Create Table: CREATE TABLE `testtrigger` (
>  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
>  `foo` char(10) NOT NULL,
>  PRIMARY KEY (`id`)
> ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
>
> Here's what I want to do: if no value is supplied for `foo`, or if a NULL
> value is supplied for `foo`, I want to set it to a particular value.
>
> I tried things like this:
>
> SET NEW.foo = IFNULL(NEW.foo,'ok')
>
> But that didn't work.
>
> If you point me in the right direction, I'll be okay from there (I hope).
>
> Thanks.
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@stripped
> Web site: www.the-infoshop.com
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
Trigger?Jerry Schwartz20 Dec
  • Re: Trigger?Michael Dykman21 Dec
    • RE: Trigger?Jerry Schwartz21 Dec
  • Re: Trigger?Wagner Bianchi21 Dec
    • RE: Trigger?Jerry Schwartz21 Dec
      • Re: Trigger?Wagner Bianchi22 Dec