sqlite 创建触发器

–创建表
CREATE TABLE land (
“dkbm” “TEXT” ,
“HTID” “TEXT” );
CREATE TABLE “trigger_record” (
“table_name” TEXT,
“table_id” TEXT,
“record_time” datetime
);
–创建触发器
CREATE TRIGGER IF NOT EXISTS trigger_record_log AFTER UPDATE ON land
WHEN 0 ==(SELECT count(*) FROM trigger_record WHERE table_id=new.rowid)
BEGIN
INSERT INTO trigger_record (table_name,table_id,record_time) VALUES (‘land’,new.rowid,datetime(‘now’));
END;

–测试
UPDATE land set htid=’13’ WHERE land.dkbm=’5117021012010301103’
– DROP TRIGGER trigger_record_log