07.12.2009, 11:34
Perhaps use a trigger.
[code=sql]
CREATE TRIGGER IF NOT EXISTS trg_logstuff AFTER INSERT ON `table1`
BEGIN
INSERT INTO `table2` ( `col1` , `col2` ) VALUES ( new.`col1` , new.`col2` );
END
[/code]
[code=sql]
CREATE TRIGGER IF NOT EXISTS trg_logstuff AFTER INSERT ON `table1`
BEGIN
INSERT INTO `table2` ( `col1` , `col2` ) VALUES ( new.`col1` , new.`col2` );
END
[/code]