sqlite execute sql file code example

Example: sqlite execute from file

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