Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix a LHS/RHS mixup in the rowvalue documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
db4e5cec36e1353c8d64ea2a4611e084 |
User & Date: | drh 2016-09-23 11:32:36.966 |
Context
2016-09-23
| ||
14:33 | Add an example of using row values in an UPDATE to the row value document. (check-in: 0bc1f4cfc7 user: drh tags: trunk) | |
11:32 | Fix a LHS/RHS mixup in the rowvalue documentation. (check-in: db4e5cec36 user: drh tags: trunk) | |
2016-09-22
| ||
18:03 | Provide for alternative document titles using <alt-title>...</alt-title>. Have the document page come up with the first sublist (containing lists of other documents) open automatically. (check-in: 22726478ad user: drh tags: trunk) | |
Changes
Changes to pages/rowvalue.in.
︙ | ︙ | |||
88 89 90 91 92 93 94 | (7,8,9) IN (SELECT * FROM t2), -- 0 (1,3,5) IN (SELECT * FROM t2); -- NULL </codeblock> <h2>Row Values In UPDATE Statements</h2> <p>Row values can also be used in the SET clause of an [UPDATE] statement. | | | 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 | (7,8,9) IN (SELECT * FROM t2), -- 0 (1,3,5) IN (SELECT * FROM t2); -- NULL </codeblock> <h2>Row Values In UPDATE Statements</h2> <p>Row values can also be used in the SET clause of an [UPDATE] statement. The LHS must be a list of column names. The RHS can be any row value. For example: <codeblock> UPDATE tab3 SET (a,b,c) = (SELECT x,y,z FROM tab4 WHERE tab4.w=tab3.d); |
︙ | ︙ |