Need help with a simple trigger

[Darren White]

I have a table with continually updated updated values. I want to log particular rows and columns to another table.

the following sql command and trigger gives this error:
update pgs.b04_reel_data set tension_potmeter="1" WHERE id=1;
Error code 1054. Unknown column 'id' in 'field list'

Hopefully I just need some help with syntax here...


-- Trigger DDL Statements
DELIMITER $$

USE `pgs`$$

CREATE TRIGGER `log01_after_update`
AFTER UPDATE ON `b04_reel_data` FOR EACH ROW
BEGIN
IF id="1" THEN
INSERT INTO log02_str_tension (str_reel_01) VALUES (NEW.tension_potmeter);
END IF;
IF id="2" THEN
INSERT INTO log02_str_tension (str_reel_02) VALUES (NEW.tension_potmeter);
END IF;
END;

$$