小陈的博客

CREATE TRIGGER 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) VALUES

–创建表 CREATE TABLE land ( “dkbm” “TEXT” , “HTID” “TEXT” ); CREATE TABLE “trigger_record” ( “table_name” TEXT, “table_id” TEXT ); –创建触发器 CREATE TRIGGER IF NOT EXISTS trigger_record_log AFT