Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in the CLI document. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
dece3aa0cccf9dacab2b9d14b3155e41 |
| User & Date: | drh 2018-01-22 17:58:40 |
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 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 recommeded 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> |
| |
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>
|