script1

来自「这是Getting Started With Sqlite 的相关示例代码和帮助」· 代码 · 共 20 行

--  This is an example of last_insert_rowid()
--
--
--
PRAGMA synchronous=OFF;
select * from test;
insert into test (b) values (3);
select last_insert_rowid();
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
insert into test (b) values (last_insert_rowid() + 4);
select case b when 1 then 'one' when  2 then 'two' else 'other' end  from test;
.tables
.q