Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Mention piped source option for .import command. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
7652db76ff66790838decde34f32a9b3 |
| User & Date: | larrybr 2021-04-01 18:24:40 |
Context
|
2021-04-23
| ||
| 13:15 | Merge in the latest branch-3.35 changes. (check-in: 1545c4fd49 user: drh tags: trunk) | |
|
2021-04-02
| ||
| 16:19 | Mention piped source option for .import command. (check-in: 3a66d34730 user: larrybr tags: branch-3.35) | |
|
2021-04-01
| ||
| 18:24 | Mention piped source option for .import command. (check-in: 7652db76ff user: larrybr tags: trunk) | |
|
2021-03-26
| ||
| 18:29 | Merge the documentation updates on the 3.35 branch into trunk. (check-in: da382790f1 user: drh tags: trunk) | |
Changes
Changes to pages/cli.in.
| ︙ | ︙ | |||
689 690 691 692 693 694 695 |
}</tclscript>
<tcl>hd_fragment csv {CSV import} {.import}</tcl>
<h2>Importing CSV files</h2>
<p>Use the ".import" command to import CSV (comma separated value) data into
an SQLite table. The ".import" command takes two arguments which are the
| | | > > | 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 |
}</tclscript>
<tcl>hd_fragment csv {CSV import} {.import}</tcl>
<h2>Importing CSV files</h2>
<p>Use the ".import" command to import CSV (comma separated value) data into
an SQLite table. The ".import" command takes two arguments which are the
source from which CSV data is to be read and the name of the
SQLite table into which the CSV data is to be inserted. The source argument
is the name of a file to be read or, if it begins with a "|" character,
specifies a command which will be run to produce the input CSV data.
<p>Note that it is important to set the "mode" to "csv" before running the
".import" command. This is necessary to prevent the command-line shell
from trying to interpret the input file text as some other format.
<tclscript>DisplayCode {
sqlite> (((.import C:/work/somedata.csv tab1)))
|
| ︙ | ︙ |