Running a Sqlite3 Script from Command Line Running a Sqlite3 Script from Command Line bash bash

Running a Sqlite3 Script from Command Line


sql bash sqlite shell

The parameter you give to the sqlite3 program is the database file name.

To execute commands from a file, you must redirect the input to that file:

$ sqlite3 mydatabase.db < SQLTableTransfer

or tell it to read from that file:

$ sqlite3 mydatabase.db ".read SQLTableTransfer"

sql bash sqlite shell

You can get a list of the spatial tables as follows:

echo "SELECT f_table_name FROM geometry_columns;" | spatialite -noheader -silent your_db.sqlite

sql bash sqlite shell

For the lazy who want to just dump this into their .bashrc:

### Execute an sqlite3 file on a given dbsql3-exec () {  # TODO: write a  --help flag that doubles as error handling  # TODO: Ensure that $1 is a db; Else display --help  # TODO: Ensure that $2 is a .sql file; Else display --help  # TODO: Probably store a backup (or at least a flag)...  sqlite3 $1 ".read $2"  true}

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last