Please register and / or log in to edit. Anonymous Wiki edits are disabled to protect against vandalism.
BEGIN TRANSACTION;before other SQL commands. When done, and before closing SQLiteSpy, execute
COMMIT TRANSACTION;to save your changes.
CREATE VIRTUAL TABLE temp.t1 USING csv(filename='thefile.csv'); SELECT * FROM t1;
VACUUM;SQL command is available as a menu item at
Menu → Execute → Vacuum Database.