MySQL AB :: MySQL Forums :: SQLite :: output to SQLite 3 to csv
Connect to sqlite database:
# sqlite3.exe {yourdatabase.db}sqlite>
sqlite> .schema
sqlite> .output mytables_schema.txt
sqlite> .separator "\t"
sqlite> SELECT * FROM {your_database} LIMIT 5;
sqlite> .header ON
sqlite> .mode csv
sqlite> .separator "\t"
sqlite> .mode list
sqlite> .mode tabs
sqlite> .output yourtable.csv
sqlite> .quit
quick solution:
sqlite> .mode tabs
sqlite> .output yourtable.csv
