Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typos in the CSV extension documentation. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | branch-3.20 |
| Files: | files | file ages | folders |
| SHA3-256: |
780ee679bd95c19ee4cc8968c101a4c0 |
| User & Date: | drh 2017-08-21 00:18:33 |
Context
|
2017-08-24
| ||
| 16:32 | Version 3.20.1 (check-in: b75bf48ce1 user: drh tags: release, version-3.20.1, branch-3.20) | |
|
2017-08-21
| ||
| 00:18 | Fix typos in the CSV extension documentation. (check-in: 780ee679bd user: drh tags: branch-3.20) | |
|
2017-08-11
| ||
| 01:11 | Fix an error in the FTS5 extension mechanism documentation. (check-in: 2d4dd1d10c user: drh tags: branch-3.20) | |
Changes
Changes to pages/csv.in.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
..
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
large amounts of comma-separated value content. The CSV virtual table is also useful as a template source file for implementing other virtual tables. </p> <p> The CVS virtual table is not built into the SQLite amalgamation. It is available as a [https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/misc/csv.c|separate source file] that can be compiled into a [loadable extension]. Typical usage of the CSV virtual table from the [command-line shell] would be something like this: <codeblock> ................................................................................ <li><p><b>data=</b><i>TEXT</i> <p>The <b>data=</b> argument specifies that <i>TEXT</i> is the literal content of the CSV file. <li><p><b>schema=</b><i>SCHEMA</i> <p> The <b>schema=</b> argument specifies a [CREATE TABLE] statement that the CVS virtual table passes to the [sqlite3_declare_vtab()] interface in order to define the number and names of the columns in the virtual table. If both the <b>schema=</b> and the <b>columns=</b> arguments are omitted, then the CVS virtual table reads the first row of the input content in order to determine the number of columns and names the columns <b>cNNN</b> where <b>NNN</b> values are consecutive integers. It is not allowed to have both <b>schema=</b> and <b>columns=</b> arguments. <li><p><b>columns=</b><i>N</i> <p>The <b>columns=</b><i>N</i> argument causes the virtual table to have exactly <i>N</i> columns. If the input data contains more columns than this, then the excess columns are ignored. If the input data contains fewer columns, then extra columns are filled with NULL. </u> |
|
|
|
|
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
..
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
large amounts of comma-separated value content. The CSV virtual table is also useful as a template source file for implementing other virtual tables. </p> <p> The CSV virtual table is not built into the SQLite amalgamation. It is available as a [https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/misc/csv.c|separate source file] that can be compiled into a [loadable extension]. Typical usage of the CSV virtual table from the [command-line shell] would be something like this: <codeblock> ................................................................................ <li><p><b>data=</b><i>TEXT</i> <p>The <b>data=</b> argument specifies that <i>TEXT</i> is the literal content of the CSV file. <li><p><b>schema=</b><i>SCHEMA</i> <p> The <b>schema=</b> argument specifies a [CREATE TABLE] statement that the CSV virtual table passes to the [sqlite3_declare_vtab()] interface in order to define the number and names of the columns in the virtual table. If both the <b>schema=</b> and the <b>columns=</b> arguments are omitted, then the CSV virtual table reads the first row of the input content in order to determine the number of columns and names the columns <b>cNNN</b> where <b>NNN</b> values are consecutive integers. It is not allowed to have both <b>schema=</b> and <b>columns=</b> arguments. <li><p><b>columns=</b><i>N</i> <p>The <b>columns=</b><i>N</i> argument causes the virtual table to have exactly <i>N</i> columns. If the input data contains more columns than this, then the excess columns are ignored. If the input data contains fewer columns, then extra columns are filled with NULL. </u> |