SQLite Trigger

Trigger

CREATE TABLE audit(
studentno INT NOT NULL,
entry_date TEXT NOT NULL
);
		    

CREATE TRIGGER audit_log AFTER INSERT ON student
BEGIN
   INSERT INTO audit(studentno, entry_date) VALUES (NEW.studentno, datetime('now'));
END;
		    

INSERT INTO student(studentno, studentname,loginpwd,sex,majorid,phone,email,borndate)
VALUES('S016','何建宁','9999','男',3,'13288889900',NULL,'1976-6-8');
		    

列出触发器

SELECT * FROM sqlite_master
WHERE type = 'trigger';
		    

删除触发器

DROP TRIGGER audit_log;