Documentation Source Text

Check-in [2fac94a5a3]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update the size and speed spreadsheet. Simplifications to text in the CLI document.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 2fac94a5a309e2c9368d66762414e0261c6563818cc55248ea1de2a43eac0247
User & Date: drh 2018-01-18 19:07:40.251
Context
2018-01-18
20:15
Wording improvements and typo fixes. (check-in: 5cbf9f2c9d user: drh tags: trunk)
19:07
Update the size and speed spreadsheet. Simplifications to text in the CLI document. (check-in: 2fac94a5a3 user: drh tags: trunk)
2018-01-16
21:01
Add new result codes to the rescode.in document. Mention the new sqlite3_vtab_collation() interface in the change log. (check-in: e3685f5763 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to misc/speed-size-graph.ods.

cannot compute difference between binary files

Changes to pages/cli.in.
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
<tclscript>DisplayCode {
sqlite> (((.system xdg-open dataout.csv)))
}</tclscript>

<tcl>hd_fragment exexcel* {export to excel}</tcl>
<h2> Export to Excel </h2>

<p>To make it easier to export to a spreadsheet, the CLI provides the
".excel" command, which capture the output of a single query and sends
that result to the default spreadsheet program on the host computer.
Use it like this:

<tclscript>DisplayCode {
sqlite> (((.excel)))
sqlite> (((SELECT * FROM tab;)))
}</tclscript>








|
|
|







714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
<tclscript>DisplayCode {
sqlite> (((.system xdg-open dataout.csv)))
}</tclscript>

<tcl>hd_fragment exexcel* {export to excel}</tcl>
<h2> Export to Excel </h2>

<p>To simplify export to a spreadsheet, the CLI provides the
".excel" command which captures the output of a single query and sends
that output to the default spreadsheet program on the host computer.
Use it like this:

<tclscript>DisplayCode {
sqlite> (((.excel)))
sqlite> (((SELECT * FROM tab;)))
}</tclscript>