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