Sqlite 复制表结构和数据

复制表结构

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

复制表结构和数据

create table newTb as select * from oldTb;
原文地址:https://www.cnblogs.com/caoyc/p/5019256.html