vendredi 30 octobre 2015

SQLite JSON1 example for JSON extract\set

SQLite has now an experimental JSON1 extention to work with JSON fields. The functions too choose from look promising, but I don't get how to use them in the context of a query.

Suppose I created the following table:

sqlite> create table user(name,phone);
sqlite> insert into user values('oz', json_array(['+491765','+498973']));

The documentation shows how to use json_each in a query, but all other functions lack some in context documentation.

Can someone with SQLite experience provide a few examples of how to use:

  • json_extract
  • json_set

Aucun commentaire:

Enregistrer un commentaire