Sqlite 复制表结构和数据

复制表结构

create table newTb as select * from oldTb where 1=0;

 

复制表结构和数据

create table newTb as select * from oldTb；