** Various scripts scan this source file in order to generate HTML ** documentation, headers files, or other derived files. The formatting ** of the code in this file is, therefore, important. See other comments
它与Parser关系紧密,根据语法分析树生成VDBE程序执行SQL语句的功能。 由诸多文件构成:trigger.c, update.c, insert.c, delete.c, select.c, where.c等文件。这些文件生成相应的VDBE程序指令,比如SELECT语句就由select.c生成。下面是一个读操作中打开表的代码的生成实现: /* Generate code that will open a ta...
SQLite创建触发器语句: CREATETRIGGERdatabase_name.trigger_name BEFOREINSERTONtable_nameFOREACHROW BEGIN stmt1; stmt2; ... END; SQLite创建视图语句: CREATEVIEWdatabase_name.view_nameAS SELECTstatement...; SQLite创建虚拟表声明: CREATEVIRTUALTABLEdatabase_name.table_nameUSINGweblog( access.log ); or...
-- 创建触发器,在插入数据到 basic_table 时记录日志 CREATE TABLE log_table ( log_id INTEGER PRIMARY KEY AUTOINCREMENT, table_name TEXT, operation TEXT, operation_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TRIGGER trg_after_insert_basic_table AFTER INSERT ON basic_table BEGIN INSERT INTO...
CREATE TRIGGER CREATE VIEW DELETE DETACH DATABASE DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW END TRANSACTION EXPLAIN 表达式 INSERT ON CONFLICT子句 PRAGMA REINDEX REPLACE ROLLBACK TRANSACTION SELECT UPDATE VACUUM ALTER TABLE SQLite版本的的ALTER TABLE命令允许用户重命名或添加新的字段到已有表中,不能从表...
comment COMMIT TRANSACTION COPY CREATE INDEX CREATE TABLE CREATE TRIGGER CREATE VIEW DELETE DETACH DATABASE DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW END TRANSACTION EXPLAIN expression INSERT ON CONFLICT clause PRAGMA REPLACE ROLLBACK TRANSACTION ...
); SQLite CREATE TRIGGER语句 1 2 3 4 5 6 7 CREATE TRIGGER database_name.trigger_name BEFORE INSERT ON table_name FOR EACH ROW BEGIN stmt1; stmt2; ... END; SQLite CREATE VIEW语句 1 2 CREATE VIEW database_name.view_name AS SELECT statement...; SQLite...
comment COMMIT TRANSACTION COPY CREATE INDEX CREATE TABLE CREATE TRIGGER CREATE VIEW DELETE DETACH DATABASE DROP INDEX DROP TABLE DROP TRIGGER DROP VIEW ENDTRANSACTION EXPLAIN expression INSERT ONCONFLICT clause PRAGMA REPLACE ROLLBACK TRANSACTION
Read-only connection, recursive trigger, foreign key validation support etc. using SQLiteConfig class. SQLiteConfig config = new SQLiteConfig(); // config.setReadOnly(true); config.setSharedCache(true); config.recursiveTriggers(true); // ... other configuration can be set via SQLiteConfig obje...
它通过SQL编译器(SQL Complier)来实现SQL语言对数据库进行操作,支持大部分的SQL命令,如attach database、begin transaction、comment、commit transaction、copy、create index、create table、create trigger、create view、delete、detach database、drop index、drop table、drop trigger、drop view、end transaction、...