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
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
The INSERT statement
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The INSERT statement is used to insert new records into a database table. The following sections describe the various operation modes of the jOOQ INSERT statement.
Table of contents
- 3.5.4.1.
- INSERT .. VALUES
- 3.5.4.2.
- INSERT .. DEFAULT VALUES
- 3.5.4.3.
- INSERT .. SET
- 3.5.4.4.
- INSERT .. SELECT
- 3.5.4.5.
- INSERT .. ON DUPLICATE KEY UPDATE
- 3.5.4.6.
- INSERT .. ON DUPLICATE KEY UPDATE .. EXCLUDED
- 3.5.4.7.
- INSERT .. ON DUPLICATE KEY UPDATE .. SET ALL TO EXCLUDED
- 3.5.4.8.
- INSERT .. ON DUPLICATE KEY IGNORE
- 3.5.4.9.
- INSERT .. ON CONFLICT .. EXCLUDED
- 3.5.4.10.
- INSERT .. ON CONFLICT .. SET ALL TO EXCLUDED
- 3.5.4.11.
- INSERT .. ON CONFLICT
- 3.5.4.12.
- INSERT .. RETURNING
| previous : next |
References to this page
- Readonly column behaviour
- The WITH clause
- UPDATE .. RETURNING
- The MERGE statement
- Defaults
- Identities
- WITH CHECK OPTION
- The VALUES() table constructor
- Data change delta tables
- Readonly columns
- Tuples or row value expressions
- Policies
- CRUD with UpdatableRecords
- Simple CRUD
- Logging with SQLExceptionLoggerListener
- Readonly columns
Feedback
Do you have any feedback about this page? We'd love to hear it!