Documentation Source Text

Check-in [db4e5cec36]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a LHS/RHS mixup in the rowvalue documentation.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: db4e5cec36e1353c8d64ea2a4611e0842c2e6d94
User & Date: drh 2016-09-23 11:32:36
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/rowvalue.in.

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 RHS must be a list of column names.  The LHS 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);







|







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);