dimanche 17 janvier 2016

Exporting all blobs from sqlite to a files

Using this command:

sqlite3 my.db "SELECT writefile('object0.jpg', MyBlob) FROM MyTable WHERE id = 1"    

I can save an image stored as blob in a table in my db.
How can I alter this so that all the images are saved instead of just 1?

Aucun commentaire:

Enregistrer un commentaire