SQLite Forum

The sql statements got joined - it should be

select 1 as id, 100 as value into #tmp; 

update a set a.value = 2000 from #tmp a where a.id = 1;