1.新建表 DROP TABLE IF EXISTS "t_journey"; CREATE TABLE t_journey ( 'index' INTEGER PRIMARY KEY AUTOINCREMENT, 'title' TEXT NOT NULL,'content' TEXT NOT NULL,'createTime' timestamp NOT NULL DEFAULT (datetime('now','localtime')), 'changeTime' timestamp NOT NULL DEFAULT (datetime('now','localtime')), 'GPSL' REAL, 'GPSR' REAL ); 2.插入数据 INSERT INTO t_journey(title,content,GPSL,GPSR) VALUES('aaa','bbbb',22.00,33.00); 3.更新数据 UPDATE t_journey SET title = 'eeee' & changeTime = datetime('now','localtime') WHERE "index" = 1