Insert SQL data to txt file

Question

I have a database named = many_cars with the table "cars" and im trying to copy all the cars with the color = silver and make = ford and ORDER BY LicenseNumber to my txt file called silver-ford.txt. What i have tried is to first

This should be done in bash and with SQLITE3

SELECT * FROM cars WHERE Color='Silver' AND Make='Ford'
ORDER BY LicenseNumber
INSERT INTO silver-fords.txt

You need to write some kind of a script. e.g write a python script that runs that query and writes the output to a txt file — Jon Ekiz, Oct 12 '17 at 22:46
@JonEkiz im pretty sure thats not needed.. there must be something im missing or not thinking about. — Peterssoen, Oct 12 '17 at 22:48
maybe this helps ? : https://stackoverflow.com/questions/6076984/how-do-i-save-the-result-of-a-query-as-a-csv-file — Jon Ekiz, Oct 12 '17 at 22:56
What OS are you runing? Do you have SQLITE3 client installed? — z atef, Oct 13 '17 at 00:13
Running osx, sorry for not saying that this should be done in bash and yes with SQLITE3 — Peterssoen, Oct 13 '17 at 06:10

score 1 · Accepted Answer · answered Oct 12 '17 at 23:46

Here is a very nice tutorial. CSV is the same as TXT - simply flat file, you can change extention after exprot, if you like.

Choose a mode, set header option and set destination. Than run your select

.headers on
.mode csv
.output data.csv
SELECT...

Insert SQL data to txt file

1 Answers1