You could try the SQLite ATTACH DATABASE command to attach another (empty) database and then use basic SQL to move the data. Something like:
You may need the new table to have a different name.Qt Code:
ATTACH DATABASE filename AS newdb; CREATE TABLE newdb.tablename AS SELECT * FROM tablename WHERE timeframe conditions;To copy to clipboard, switch view to plain text mode
Bookmarks