org.jooq

Interface InsertSetStep<R extends Record>

public interface InsertSetStep<R extends Record>

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

Author:

Lukas Eder

Method Summary

Modifier and Type	Method and Description
InsertValuesStepN<R>	columns(java.util.Collection<? extends Field<?>> fields) Set the columns for insert.
InsertValuesStepN<R>	columns(Field<?>... fields) Set the columns for insert.
<T1> InsertValuesStep1<R,T1>	columns(Field<T1> field1) Set the columns for insert.
<T1,T2> InsertValuesStep2<R,T1,T2>	columns(Field<T1> field1, Field<T2> field2) Set the columns for insert.
<T1,T2,T3> InsertValuesStep3<R,T1,T2,T3>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3) Set the columns for insert.
<T1,T2,T3,T4> InsertValuesStep4<R,T1,T2,T3,T4>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4) Set the columns for insert.
<T1,T2,T3,T4,T5> InsertValuesStep5<R,T1,T2,T3,T4,T5>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Set the columns for insert.
<T1,T2,T3,T4,T5,T6> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> 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) Set the columns for insert.
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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) Set the columns for insert.
InsertOnDuplicateStep<R>	defaultValues() Add an empty record with default values.
InsertOnDuplicateStep<R>	select(Select<?> select) Use a SELECT statement as the source of values for the INSERT statement.
<T> InsertSetMoreStep<R>	set(Field<T> field, Field<T> value) Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	set(Field<T> field, Select<? extends Record1<T>> value) Set a value for a field in the INSERT statement.
<T> InsertSetMoreStep<R>	set(Field<T> field, T value) Set a value for a field in the INSERT statement.
InsertSetMoreStep<R>	set(java.util.Map<?,?> map) Set values in the INSERT statement.
InsertSetMoreStep<R>	set(Record record) Set values in the INSERT statement.
InsertValuesStepN<R>	values(java.util.Collection<?> values) Add values to the insert statement with implicit field names.
InsertValuesStepN<R>	values(Field<?>... values) Add values to the insert statement with implicit field names.
InsertValuesStepN<R>	values(java.lang.Object... values) Add values to the insert statement with implicit field names.

Method Detail

columns

@Support
InsertValuesStepN<R> columns(Field<?>... fields)

Set the columns for insert.

columns

@Support
InsertValuesStepN<R> columns(java.util.Collection<? extends Field<?>> fields)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1> InsertValuesStep1<R,T1> columns(Field<T1> field1)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2> InsertValuesStep2<R,T1,T2> columns(Field<T1> field1,
                                                                                                                     Field<T2> field2)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3> InsertValuesStep3<R,T1,T2,T3> columns(Field<T1> field1,
                                                                                                                           Field<T2> field2,
                                                                                                                           Field<T3> field3)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4> InsertValuesStep4<R,T1,T2,T3,T4> columns(Field<T1> field1,
                                                                                                                                 Field<T2> field2,
                                                                                                                                 Field<T3> field3,
                                                                                                                                 Field<T4> field4)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5> InsertValuesStep5<R,T1,T2,T3,T4,T5> columns(Field<T1> field1,
                                                                                                                                       Field<T2> field2,
                                                                                                                                       Field<T3> field3,
                                                                                                                                       Field<T4> field4,
                                                                                                                                       Field<T5> field5)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> 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)

Set the columns for insert.

columns

@Generated(value="This class was generated using jOOQ-tools")
 @Support
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> 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)

Set the columns for insert.

set

@Support
<T> InsertSetMoreStep<R> set(Field<T> field,
                                       T value)

Set a value for a field in the INSERT statement.

set

@Support
<T> InsertSetMoreStep<R> set(Field<T> field,
                                       Field<T> value)

Set a value for a field in the INSERT statement.

set

@Support
<T> InsertSetMoreStep<R> set(Field<T> field,
                                       Select<? extends Record1<T>> value)

Set a value for a field in the INSERT statement.

set

@Support
InsertSetMoreStep<R> set(java.util.Map<?,?> map)

Set values in the INSERT statement.

Keys can either be of type String, Name, or Field.

Values can either be of type <T> or Field<T>. jOOQ will attempt to convert values to their corresponding field's type.

set

@Support
InsertSetMoreStep<R> set(Record record)

Set values in the INSERT statement.

This is the same as calling set(Map) with the argument record treated as a Map<Field<?>, Object>, except that the Record.changed() flags are taken into consideration in order to update only changed values.

See Also:

set(Map)

values

@Support
InsertValuesStepN<R> values(java.lang.Object... values)

Add values to the insert statement with implicit field names.

values

@Support
InsertValuesStepN<R> values(Field<?>... values)

Add values to the insert statement with implicit field names.

values

@Support
InsertValuesStepN<R> values(java.util.Collection<?> values)

Add values to the insert statement with implicit field names.

defaultValues

@Support(value={ASE,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,SYBASE})
InsertOnDuplicateStep<R> defaultValues()

Add an empty record with default values.

select

@Support
InsertOnDuplicateStep<R> select(Select<?> select)

Use a SELECT statement as the source of values for the INSERT statement.

This variant of the INSERT .. SELECT statement does not allow for specifying a subset of the fields inserted into. It will insert into all fields of the table specified in the INTO clause. Use DSLContext.insertInto(Table, Field...) or DSLContext.insertInto(Table, Collection) instead, to define a field set for insertion.