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!
[Solved] SQLite - Execute SQL query in a script or from Terminal
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2741
Topic starter
May 14, 2022 4:08 AM
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 ... 😊