编辑代码

create table fibonacci(
    id integer primary key,
    val int
);

insert into fibonacci values(1,1);
insert into fibonacci (val) values(1);
insert into fibonacci (val) values(2);

insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);
insert into fibonacci (val) select sum(val) from (select val from fibonacci order by id desc limit 2);

select * from fibonacci;