Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in the CLI document. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
dece3aa0cccf9dacab2b9d14b3155e41 |
| User & Date: | drh 2018-01-22 17:58:40.468 |
Context
|
2018-01-22
| ||
| 18:05 | Fix a typo in the vtab document. (check-in: 2105719672 user: drh tags: trunk) | |
| 17:58 | Fix a typo in the CLI document. (check-in: dece3aa0cc user: drh tags: trunk) | |
| 17:53 | Fix typos in the lemon.html document. (check-in: 62f434c8b8 user: drh tags: trunk) | |
Changes
Changes to pages/cli.in.
| ︙ | ︙ | |||
1047 1048 1049 1050 1051 1052 1053 | sqlite> CREATE TABLE x1(a, b, c); <i>-- Create table in database </i> sqlite> .expert sqlite> SELECT * FROM x1 WHERE a=? AND b>?; <i>-- Analyze this SELECT </i> CREATE INDEX x1_idx_000123a7 ON x1(a, b); 0|0|0|SEARCH TABLE x1 USING INDEX x1_idx_000123a7 (a=? AND b>?) | | | 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 | sqlite> CREATE TABLE x1(a, b, c); <i>-- Create table in database </i> sqlite> .expert sqlite> SELECT * FROM x1 WHERE a=? AND b>?; <i>-- Analyze this SELECT </i> CREATE INDEX x1_idx_000123a7 ON x1(a, b); 0|0|0|SEARCH TABLE x1 USING INDEX x1_idx_000123a7 (a=? AND b>?) sqlite> CREATE INDEX x1ab ON x1(a, b); <i>-- Create the recommended index </i> sqlite> .expert sqlite> SELECT * FROM x1 WHERE a=? AND b>?; <i>-- Re-analyze the same SELECT </i> (no new indexes) 0|0|0|SEARCH TABLE x1 USING INDEX x1ab (a=? AND b>?) </codeblock> |
| ︙ | ︙ |