MySQL. Триггер.

DELIMITER |
CREATE TRIGGER update_mytable AFTER INSERT ON mytable
FOR EACH ROW BEGIN
   INSERT INTO another_table SET my_column = 'my_value', row_id = NEW.id;
END;