Interface MergeColumnsStep<R extends Record>

All Superinterfaces:

MergeKeyStepN<R>, MergeValuesStepN<R>

All Known Subinterfaces:

MergeUsingStep<R>

@Deprecated(forRemoval=true,
            since="3.14")
public interface MergeColumnsStep<R extends Record>
extends MergeKeyStepN<R>

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

This type is used for the Merge's DSL API.

Example:

DSLContext create = DSL.using(configuration);

create.mergeInto(table)
      .using(select)
      .on(condition)
      .whenMatchedThenUpdate()
      .set(field1, value1)
      .set(field2, value2)
      .whenNotMatchedThenInsert(field1, field2)
      .values(value1, 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 Summary

Modifier and Type	Method	Description
@NotNull MergeKeyStepN<R>	columns(Collection<? extends Field<?>> fields)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
@NotNull MergeKeyStepN<R>	columns(Field<?>... fields)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1> @NotNull MergeKeyStep1<R,T1>	columns(Field<T1> field1)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2> @NotNull MergeKeyStep2<R,T1,T2>	columns(Field<T1> field1, Field<T2> field2)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3> @NotNull MergeKeyStep3<R,T1,T2,T3>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5> @NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6> @NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7> @NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8> @NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9> @NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> @NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> @NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> @NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> @NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> @NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> @NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> @NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> @NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> @NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> @NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> @NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> @NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> @NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	columns(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)	Deprecated, for removal: This API element is subject to removal in a future version. - [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Methods inherited from interface MergeKeyStepN

key, key

Methods inherited from interface MergeValuesStepN

select, values, values, values

Method Details

columns

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull MergeKeyStepN<R> columns(Field<?>... fields)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Set the columns for merge (H2-specific syntax).

This statement is available from DSL syntax only. It is known to be supported in some way by any of these dialects:

H2	H2 natively supports this special syntax	https://www.h2database.com/html/commands.html#merge_into
HANA	HANA natively supports this syntax	http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/fc06a7751910149892c0d09be21a38/content.htm
PostgreSQL	This database can emulate the H2-specific MERGE statement via INSERT … ON CONFLICT DO UPDATE	http://www.postgresql.org/docs/9.5/static/sql-insert.html
DB2, Firebird, HSQLDB, Oracle, SQL Server, Sybase SQL Anywhere	These databases can emulate the H2-specific MERGE statement using a standard SQL MERGE statement, without restrictions	See DSLContext.mergeInto(Table) for the standard MERGE statement

columns

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@NotNull MergeKeyStepN<R> columns(Collection<? extends Field<?>> fields)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Set the columns for merge (H2-specific syntax).

See Also:

• columns(Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1> @NotNull MergeKeyStep1<R,T1> columns(Field<T1> field1)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2> @NotNull MergeKeyStep2<R,T1,T2> columns(Field<T1> field1,
 Field<T2> field2)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3> @NotNull MergeKeyStep3<R,T1,T2,T3> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4> @NotNull MergeKeyStep4<R,T1,T2,T3,T4> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5>
@NotNull MergeKeyStep5<R,T1,T2,T3,T4,T5> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6>
@NotNull MergeKeyStep6<R,T1,T2,T3,T4,T5,T6> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7>
@NotNull MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8>
@NotNull MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9>
@NotNull MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
@NotNull MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
@NotNull MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
@NotNull MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
@NotNull MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
@NotNull MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
@NotNull MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
@NotNull MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
@NotNull MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
@NotNull MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
@NotNull MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
@NotNull MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
@NotNull MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20,
 Field<T21> field21)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)

columns

@NotNull
@CheckReturnValue
@Support({AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DATABRICKS,DB2,DERBY,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,HSQLDB,INFORMIX,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES_9_5,REDSHIFT,SNOWFLAKE,SQLSERVER,SYBASE,TERADATA,VERTICA,YUGABYTEDB})
@Deprecated(forRemoval=true,
            since="3.14")
<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
@NotNull MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22> columns(Field<T1> field1,
 Field<T2> field2,
 Field<T3> field3,
 Field<T4> field4,
 Field<T5> field5,
 Field<T6> field6,
 Field<T7> field7,
 Field<T8> field8,
 Field<T9> field9,
 Field<T10> field10,
 Field<T11> field11,
 Field<T12> field12,
 Field<T13> field13,
 Field<T14> field14,
 Field<T15> field15,
 Field<T16> field16,
 Field<T17> field17,
 Field<T18> field18,
 Field<T19> field19,
 Field<T20> field20,
 Field<T21> field21,
 Field<T22> field22)

Deprecated, for removal: This API element is subject to removal in a future version.

- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, via DSLContext.mergeInto(Table)

Create a new DSL UPSERT statement (SQLDialect.H2 MERGE) or SQLDialect.HANA UPSERT).

See Also:

• DSLContext.mergeInto(Table, Field...)