如何将这三句话合并？
in sqlite:
create table temp as select * from quote where code='00001'and date='20101025' ;
alter table temp add lin ;
update temp set lin=200 where code='00001';

请问，上面这三句话如何合并成一句简洁的表达？
[最优解释]

create table temp as 
select *,200 as  lin from quote 
where code='00001'and date='20101025' ;