How Can I Efficiently Dump Data from Specific SQLite3 Tables?

Extracting Data from SQLite3 Tables

This guide demonstrates efficient methods for extracting data from specific SQLite3 tables, excluding the schema. The command line provides several effective approaches.

Exporting to CSV

For importing data into other applications, a comma-separated values (CSV) file is ideal:

<code>.mode csv
.headers on
.out file.csv
select * from MyTable;</code>

.mode csv sets the output format to CSV, .headers on includes column headers, .out specifies the output file (file.csv), and the select statement retrieves all data from MyTable.

Exporting to SQL

To create an SQL file suitable for re-insertion into another SQLite database:

<code>.mode insert <target_table_name>
.out file.sql
select * from MyTable;</code>

.mode insert sets the output format to SQL INSERT statements, <target_table_name> specifies the target table name for the INSERT statements, and .out designates the output file (file.sql).

These methods allow for selective data extraction from specified SQLite3 tables in your preferred format.

The above is the detailed content of How Can I Efficiently Dump Data from Specific SQLite3 Tables?. For more information, please follow other related articles on the PHP Chinese website!