sqlite import sql file

Solutions on MaxInterview for sqlite import sql file by the best coders in the world

showing results for - "sqlite import sql file"
Viktoria
06 Jul 2016
1sqlite> .mode column							-- results as columns (optional)
2sqlite> .header on								-- columns name are displayed (optional)
3sqlite> .read c:/sqlite/commands.sql			-- executes sql code in commands.sql (text file)
4sqlite3 auction.db < commands.sql				-- Shell version
5sqlite3 my_db.db 'SELECT * FROM some_table;'	-- Shell direct query in my_db.db