SQLite efficiency questions.
#4

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]
Reply


Messages In This Thread
SQLite efficiency questions. - by Outbreak - 06.12.2009, 20:21
Re: SQLite efficiency questions. - by Outbreak - 07.12.2009, 09:10
Re: SQLite efficiency questions. - by xxmitsu - 07.12.2009, 09:41
Re: SQLite efficiency questions. - by Dabombber - 07.12.2009, 11:34

Forum Jump:


Users browsing this thread: 3 Guest(s)