Module org.jooq
Package 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();
     

    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:

    • They're operating on mutable implementations (as of jOOQ 3.x)
    • They're less composable and not easy to get right when dynamic SQL gets complex
    • They're less readable
    • They might have binary incompatible changes between minor releases
    Author:
    Lukas Eder
    • Method Detail

      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • columns

        @NotNull
        @Support
        <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)
        Set the columns for insert.
      • setNull

        @NotNull
        @Support
        <T> @NotNull InsertSetMoreStep<R> setNull​(Field<T> field)
        Set a null value for a field in the INSERT statement.

        This method is convenience for calling set(Field, Object), without the necessity of casting the Java null literal to (T).

      • set

        @NotNull
        @Support
        @NotNull InsertSetMoreStep<R> set​(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

        @NotNull
        @Support
        @NotNull 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)