Question : sqlite import sql file
Answered by : vastemonde
sqlite> .mode column -- results as columns (optional)
sqlite> .header on -- columns name are displayed (optional)
sqlite> .read c:/sqlite/commands.sql -- executes sql code in commands.sql (text file)
sqlite3 auction.db < commands.sql -- Shell version
sqlite3 my_db.db 'SELECT * FROM some_table;' -- Shell direct query in my_db.db
Source : https://www.sqlitetutorial.net/sqlite-commands/ | Last Update : Thu, 27 May 21