![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlite
小陈博客
Genius is one percent inspiration and ninety-nine percent perspiration.
展开
-
Sptialite查询空间数据并转换成Geometry,WKBReader,WKTReader使用
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原创 2020-03-29 17:30:29 · 2070 阅读 · 1 评论 -
sqlite 创建触发器
–创建表 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原创 2017-12-01 15:12:45 · 765 阅读 · 0 评论