This is a discussion on AFTER INSERT Trigger within the MySQL Database forums, part of the Database Forums category; Hi guys, I know this is a dumb question (but, I have not used triggers in years...) :-) The following is ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hi guys,
I know this is a dumb question (but, I have not used triggers in years...) :-) The following is not working... what am I missing? TIA, S. CREATE TABLE feeder(value double); CREATE TABLE dash(value double); CREATE TRIGGER upt_delta AFTER INSERT ON feeder FOR EACH ROW BEGIN UPDATE dash a SET a.delta = NEW.value; END ; INSERT INTO feeder VALUES (10.2); |