LiteDB数据库LiteDB.Studio的常用语句

SELECT $ FROM TaskDisplay;

SELECT count(*) FROM TaskDisplay;

LiteDB.Studio insert插入语句

INSERT INTO TaskDisplay VALUES {taskId: 'John',Title:'第三方'};

Update TaskDisplay Set title = 'Big' Where taskId='John'

 

 

INSERT INTO mycoll VALUES {_id:1, name: 'John'};

-- with auto-id int
INSERT INTO mycoll:INT VALUES {name:'John'}, {name:'Carlos'}