sqlite触发器

1.先创建表1和表2。

2.创建触发器，关联表2。

3.只要在创建好规则，对表1做的任何改动都会自动触发规则，添加到表2。

4.表2主键可以增加autoincrement属性。

.open test.db

create table worker(id int primary key,name text,age int);

create table Log(emp_id integer primary key autoincrement,entry_date text);

create trigger log_log after insert on worker

begin

insert into Log(emp_id, entry_date) values (new.ID, datetime('now'));

end;

insert into worker values(1,'peter',23);

sqlite> select * from worker;
1|peter|23
sqlite> .header on
sqlite> .mode column
sqlite> select * from worker;
id          name        age
----------  ----------  ----------
1           peter       23
sqlite> select * from log_log;
Error: no such table: log_log
sqlite> .table
COMPANY  Log      worker
sqlite> select * from Log;
emp_id      entry_date
----------  -------------------
1           2018-04-27 05:24:59