How To Output Using Cr (carriage Return) Instead Of Lf (line Feed) In Sqlite?

I am trying to output into a csv file and have used the following commands: once output.csv; select * from table; With the above command, it will output a csv file that uses a LF

Solution 1:

Since version 3.8.6, you can use the .separator command to also define the record separator in CSV mode:

.mode csv
.separator , "\r"
.once output.csv
select * from mytable;