Answers for "sqlite execute from file"

SQL

4

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

Posted by: Guest on May-20-2021

Source

Code answers related to "sqlite execute from file"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#