SELECT sql as schema_sql -- schemaFROM sqlite_masterWHERE type = 'table' AND name = 'oldtable';

INSERT INTO newtable SELECT * FROM oldtable;

1. retrieve schema_sql to retrieve the structure

2. run schema_sql on sqlite client

3. insert data

not like mysql, maybe need to use php to combine 1-3 into one key action.