Trigger

exdter · #1 (**permalink**) 05-27-04, 13:28

Is there some way I can make a trigger in MySQL? I want to put a default date in a date field, and can't figure out how to do it. Thanks.

guelphdad · #2 (**permalink**) 05-27-04, 13:31

I don't think you can use triggers in MySQL unless it is in version 5.

But you are only asking to set a default date, can't you set up your table to accept that?

Code:

ALTER table mytable 
change mydate
mydate date default '0000-00-00'

exdter · #3 (**permalink**) 05-27-04, 13:37

Thanks for your reply. I just get zeros in my date column now.

guelphdad · #4 (**permalink**) 05-27-04, 21:24

well yes, that would be the default. What date do you want to set to? Use that in place of the 0000-00-00

Internet Services

Web Development

Digital Marketing

Consumer Tech