Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add a new hyperlink on the cli.html page. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
03e1bee6c8778976a066f20f3c26b813 |
| User & Date: | drh 2016-04-23 16:24:24 |
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 481 482 483 484 485 486 487 488 489 |
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 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.
|
| > | |
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.
|