CREATE TRIGGER auth_trigger AFTER UPDATE on authorized
FOR EACH ROW
         INSERT INTO history
         (columnone, columntwo, columnthree) VALUES (OLD.columnone, OLD.columntwo, OLD.columnthree);


CREATE TRIGGER auth_trigger AFTER UPDATE ON authorized
FOR EACH ROW BEGIN
	INSERT INTO history
	SET table_name = "authorized", column_name = NEW.col_name, id_changed = OLD.id, old_value = OLD.value, new_value = NEW.value;
END;
|



Error
SQL query:

CREATE TRIGGER auth_trigger AFTER UPDATE ON authorized FOR EACH ROW BEGIN INSERT INTO history
SET table_name =  "authorized",
column_name = NEW.col_name,
id_changed = OLD.id,
old_value = OLD.value,
new_value = NEW.value;

END ;


MySQL said:

#1054 - Unknown column 'col_name' in 'NEW'