Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add a new hyperlink on the cli.html page. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
03e1bee6c8778976a066f20f3c26b813 |
User & Date: | drh 2016-04-23 16:24:24.089 |
Context
2016-04-26
| ||
15:37 | Add documentation for RBU vacuum to rbu.in. (check-in: 2906c27967 user: dan tags: trunk) | |
2016-04-23
| ||
16:24 | Add a new hyperlink on the cli.html page. (check-in: 03e1bee6c8 user: drh tags: trunk) | |
2016-04-22
| ||
12:14 | Update the change log for the unix temporary directory search change. (check-in: 982ce9adde user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
20 21 22 23 24 25 26 27 28 29 30 31 32 33 | set xrefChng($date) $nChng incr nChng } chng {2016-05-00 (3.13.0)} { <li>Merged the [session] extension into trunk. <li>Added the ".auth ON|OFF" command to the [command-line shell]. <li>Improved unicode filename handling in the [command-line shell] on Windows. <li>Improved resistance against goofy query planner decisions caused by incomplete or incorrect modifications to the [sqlite_stat1] table by the application. <li>Added the [sqlite3_db_config](db,[SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION]) interface which allows the [sqlite3_load_extension()] C-API to be enabled while keeping the [load_extension()] SQL function disabled for security. | > > | 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | set xrefChng($date) $nChng incr nChng } chng {2016-05-00 (3.13.0)} { <li>Merged the [session] extension into trunk. <li>Added the ".auth ON|OFF" command to the [command-line shell]. <li>Added the "--indent" option to the ".schema" and ".fullschema" commands of the command-line shell, to turn on pretty-printing. <li>Improved unicode filename handling in the [command-line shell] on Windows. <li>Improved resistance against goofy query planner decisions caused by incomplete or incorrect modifications to the [sqlite_stat1] table by the application. <li>Added the [sqlite3_db_config](db,[SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION]) interface which allows the [sqlite3_load_extension()] C-API to be enabled while keeping the [load_extension()] SQL function disabled for security. |
︙ | ︙ |
Changes to pages/cli.in.
︙ | ︙ | |||
474 475 476 477 478 479 480 | UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table','view') ORDER BY 1 </pre></blockquote> <p>In fact, if you look at the source code to the sqlite3 program | | > | | 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 | UNION ALL SELECT name FROM sqlite_temp_master WHERE type IN ('table','view') ORDER BY 1 </pre></blockquote> <p>In fact, if you look at the source code to the sqlite3 program (found in the source tree in the file [https://www.sqlite.org/src/artifact?ci=trunk&filename=src/shell.c|src/shell.c]) you'll find a query very much like the above.</p> <p>The ".indices" command works in a similar way to list all of the indices for a particular table. The ".indices" command takes a single argument which is the name of the table for which the indices are desired. Last, but not least, is the ".schema" command. With no arguments, the ".schema" command shows the original CREATE TABLE and CREATE INDEX statements that were used to build the current database. |
︙ | ︙ |