Sqlite—复制表结构和数据

复制表结构

sqlite> create table newTb as select * from oldTb where 1=0;
sqlite> create table firewall_new as select * from firewall where 1=0;

复制表结构和数据

sqlite> create table newTb as select * from oldTb；
sqlite> create table firewall_new as select * from firewall;