Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!




SQLite - Execute SQ...
 
Share:
Notifications
Clear all

[Solved] SQLite - Execute SQL query in a script or from Terminal

1 Posts
1 Users
0 Likes
1,641 Views
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2660
Topic starter  

I had to run an update SQL query, which I wanted to run in a script (so I can run it daily).
Took me a bit to find the right way to do this.

Option 1 - straight and simple SQL

sqlite3 mydatabasefile.db 'UPDATE sometbale SET afield=anotherfield;'

 

Option 2 - take the SQL statement from a file

File (myfile.sql):

UPDATE sometbale SET afield=anotherfield;

 

Shell:

sqlite3 mydatabasefile.db < myfile.sql

 

Hope this is helpful to someone ... 😊 


   
ReplyQuote

Like what you see and you'd like to help out? 

The best way to help is of course by assisting others with their questions here in the forum, but you can also help us out in other ways:

- Do your shopping at Amazon, it will not cost you anything extra but may generate a small commission for us,
- send a cup of coffee through PayPal ($5, $10, $20, or custom amount),
- become a Patreon,
- donate BitCoin (BTC), or BitCoinCash (BCH).

Share: