sqlite to csv statement
import pandas as pd conn = sqlite3.connect(db_file, isolation_level=None, detect_types=sqlite3.PARSE_COLNAMES) db_df = pd.read_sql_query("SELECT * FROM table", conn) db_df.to_csv('database.csv', index=False)
Source: stackoverflow.com
sqlite csv
sqlite> .mode csv sqlite> .output test.csv sqlite> select * from tbl1; sqlite> .output stdout
Source: stackoverflow.com