Top Description Methods
org.jooq

public Interface InsertSetStep<R extends org.jooq.Record>

Known Direct Implementers
org.jooq.impl.InsertImpl
Imports
org.jetbrains.annotations.*, java.util.Collection, .Map
This type is used for the Insert's alternative DSL API.

Example: 


DSLContext create = DSL.using(configuration);

create.insertInto(table)
      .set(field1, value1)
      .set(field2, value2)
      .newRecord()
      .set(field1, value3)
      .set(field2, value4)
      .onDuplicateKeyUpdate()
      .set(field1, value1)
      .set(field2, value2)
      .execute();

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull InsertValuesStepN<R>
columns(Field<?>... fields)

Deprecated as a consequence of Field and InsertValuesStepN being deprecated.
Set the columns for insert.
public @NotNull InsertValuesStepN<R>
columns(Collection<? extends Field<?>> fields)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Set the columns for insert.
public <T1> @NotNull InsertValuesStep1<R, T1>
columns(Field<T1> field1)

Deprecated as a consequence of Field and InsertValuesStep1 being deprecated.
Set the columns for insert.
public <T1, T2> @NotNull InsertValuesStep2<R, T1, T2>
columns(Field<T1> field1, Field<T2> field2)

Deprecated as a consequence of Field and InsertValuesStep2 being deprecated.
Set the columns for insert.
public <T1, T2, T3> @NotNull InsertValuesStep3<R, T1, T2, T3>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3)

Deprecated as a consequence of Field and InsertValuesStep3 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4> @NotNull InsertValuesStep4<R, T1, T2, T3, T4>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)

Deprecated as a consequence of Field and InsertValuesStep4 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5> @NotNull InsertValuesStep5<R, T1, T2, T3, T4, T5>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)

Deprecated as a consequence of Field and InsertValuesStep5 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6> @NotNull InsertValuesStep6<R, T1, T2, T3, T4, T5, T6>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)

Deprecated as a consequence of Field and InsertValuesStep6 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7> @NotNull InsertValuesStep7<R, T1, T2, T3, T4, T5, T6, T7>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)

Deprecated as a consequence of Field and InsertValuesStep7 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8> @NotNull InsertValuesStep8<R, T1, T2, T3, T4, T5, T6, T7, T8>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)

Deprecated as a consequence of Field and InsertValuesStep8 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9> @NotNull InsertValuesStep9<R, T1, T2, T3, T4, T5, T6, T7, T8, T9>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)

Deprecated as a consequence of Field and InsertValuesStep9 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> @NotNull InsertValuesStep10<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)

Deprecated as a consequence of Field and InsertValuesStep10 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> @NotNull InsertValuesStep11<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)

Deprecated as a consequence of Field and InsertValuesStep11 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> @NotNull InsertValuesStep12<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)

Deprecated as a consequence of Field and InsertValuesStep12 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> @NotNull InsertValuesStep13<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)

Deprecated as a consequence of Field and InsertValuesStep13 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> @NotNull InsertValuesStep14<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)

Deprecated as a consequence of Field and InsertValuesStep14 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> @NotNull InsertValuesStep15<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)

Deprecated as a consequence of Field and InsertValuesStep15 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> @NotNull InsertValuesStep16<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)

Deprecated as a consequence of Field and InsertValuesStep16 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> @NotNull InsertValuesStep17<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)

Deprecated as a consequence of Field and InsertValuesStep17 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> @NotNull InsertValuesStep18<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)

Deprecated as a consequence of Field and InsertValuesStep18 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> @NotNull InsertValuesStep19<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)

Deprecated as a consequence of Field and InsertValuesStep19 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> @NotNull InsertValuesStep20<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)

Deprecated as a consequence of Field and InsertValuesStep20 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> @NotNull InsertValuesStep21<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)

Deprecated as a consequence of Field and InsertValuesStep21 being deprecated.
Set the columns for insert.
public <T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> @NotNull InsertValuesStep22<R, T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)

Deprecated as a consequence of Field and InsertValuesStep22 being deprecated.
Set the columns for insert.
public @NotNull InsertOnDuplicateStep<R>
defaultValues()

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
Add an empty record with default values.
public @NotNull InsertOnDuplicateStep<R>
select(Select<?> select)

Deprecated as a consequence of InsertOnDuplicateStep being deprecated.
Use a SELECT statement as the source of values for the INSERT statement.
public <T> @NotNull InsertSetMoreStep<R>
set(Field<T> field, T value)

Deprecated as a consequence of Field and InsertSetMoreStep being deprecated.
Set a value for a field in the INSERT statement.
public <T> @NotNull InsertSetMoreStep<R>
set(Field<T> field, Field<T> value)

Deprecated as a consequence of Field and InsertSetMoreStep being deprecated.
Set a value for a field in the INSERT statement.
public <T> @NotNull InsertSetMoreStep<R>
set(Field<T> field, Select<? extends Record1<T>> value)

Deprecated as a consequence of Field and InsertSetMoreStep being deprecated.
Set a value for a field in the INSERT statement.
public @NotNull InsertSetMoreStep<R>
set(Map<?, ?> map)

Deprecated as a consequence of InsertSetMoreStep being deprecated.
Set values in the INSERT statement.
public @NotNull InsertSetMoreStep<R>
set(Record record)

Deprecated as a consequence of InsertSetMoreStep being deprecated.
Set values in the INSERT statement.
public <T> @NotNull InsertSetMoreStep<R>
setNull(Field<T> field)

Deprecated as a consequence of Field and InsertSetMoreStep being deprecated.
Set a null value for a field in the INSERT statement.
public @NotNull InsertValuesStepN<R>
values(Object... values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add values to the insert statement with implicit field names.
public @NotNull InsertValuesStepN<R>
values(Field<?>... values)

Deprecated as a consequence of Field and InsertValuesStepN being deprecated.
Add values to the insert statement with implicit field names.
public @NotNull InsertValuesStepN<R>
values(Collection<?> values)

Deprecated as a consequence of InsertValuesStepN being deprecated.
Add values to the insert statement with implicit field names.