Friday, 6 September 2013

Mysql trigger update field on t2 on update t1 column

Mysql trigger update field on t2 on update t1 column

I've 2 tables (t1,t2) on my test db.
CREATE TABLE IF NOT EXISTS `t1` (
`name` varchar(10) NOT NULL,
`code` varchar(10) NOT NULL,
`end_date` varchar(8) NOT NULL
);
CREATE TABLE IF NOT EXISTS `t2` (
`date` varchar(8) NOT NULL
);
I'd like to create a trigger for update t2.date (with t1.end_date value)
when update t1.end_date. I've tried this way but with no success (Variable
'OLD' is not a variable component (can't be used as XXXX.variable_name)).
CREATE TRIGGER update_date BEFORE UPDATE ON t1 FOR EACH ROW
IF NOT (t1.NEW.end_date <=> t1.OLD.end_date) THEN
SET t2.OLD.date = t2.NEW.end_date;
END IF
How can I do this? Thanks

No comments:

Post a Comment