mercredi 7 janvier 2015

Redirect the query output to a text file with sqlite on windows?

I'm doing some queries using Sqlite in Windows (I execute it as sqlite3 mydb.db) but I can't redirect the output (I'm trying to do as a normal command line way like .tables > new_db_output.txt) because sqlite runs as an a program under the command line.


In the official sqlite web page is a section called Writting results to a file but doesn't work in the way I try:


.tables .output new_db_output.txt


neither


.tables | .output new_db_output.txt


Any idea to get the output to a file?


Note: I'm using sqlite3 & windows 7.


Aucun commentaire:

Enregistrer un commentaire