Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
The UPDATE statement
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The UPDATE
statement is used to modify one or several pre-existing records in a database table. UPDATE
statements are only possible on single tables. Support for multi-table updates might be implemented in the future. An example update query is given here:
UPDATE AUTHOR SET FIRST_NAME = 'Hermann', LAST_NAME = 'Hesse' WHERE ID = 3;
create.update(AUTHOR) .set(AUTHOR.FIRST_NAME, "Hermann") .set(AUTHOR.LAST_NAME, "Hesse") .where(AUTHOR.ID.eq(3)) .execute();
The following subsections discuss the various subclauses of the DELETE
statement.
Table of contents
- 3.3.6.1.
- UPDATE .. SET
- 3.3.6.2.
- UPDATE .. SET ROW
- 3.3.6.3.
- UPDATE .. FROM
- 3.3.6.4.
- UPDATE .. WHERE
- 3.3.6.5.
- UPDATE .. ORDER BY .. LIMIT (new)
- 3.3.6.6.
- UPDATE .. RETURNING
previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!