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 (new)

3.5.4.7.

INSERT .. ON DUPLICATE KEY UPDATE .. SET ALL TO EXCLUDED (new)

3.5.4.8.

INSERT .. ON DUPLICATE KEY IGNORE

3.5.4.9.

INSERT .. ON CONFLICT .. EXCLUDED (new)

3.5.4.10.

INSERT .. ON CONFLICT .. SET ALL TO EXCLUDED (new)

3.5.4.11.

INSERT .. ON CONFLICT

3.5.4.12.

INSERT .. RETURNING