记录

查询记录。

SELECT k, v FROM kv

k	v
book	[]
music	[]
novie	[]

修改记录。字段区分大小写。

UPDATE kv SET v = '[{"id": 1, "name": "西游记"}]' WHERE k = 'book'

删除记录。

DELETE FROM kv WHERE k = 'music'

清空记录。

DELETE FROM kv