-------------------------------------------------------------------------------- js.db
|
create table if not exists model (
|
id integer primary key autoincrement,
|
name varchar(100),
|
json varchar(4000)
|
);
|
-- insert into model (name, json) values ('Test', '{"color": "#ffffff", "yaw": 0}');
|
|
select * from model;
|
select * from model where upper(name) like '%' order by id limit 10 offset 0;
|
--------------------------------------------------------------------------------
|
