Re: Why isn't this working?

[Peter Brawley]

Assuming `index` is a column in the `lighting` table ...

CREATE TRIGGER lighting_schedule_ins
AFTER INSERT ON`lighting_schedule`
FOR EACH ROW
UPDATE lighting SET NEW.lastupdated=Now() WHERE index=1;

... (one statement, so delims aren't needed), but the logic looks fishy---there's no evident relationship between between the Insert and an``index` value of 1 in the other table.