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,707 Views
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2680
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
Share: