public interface InsertOnDuplicateSetStep<R extends Record>
Insert
's DSL API.
Example:
Factory create = new Factory();
create.insertInto(table, field1, field2)
.values(value1, value2)
.values(value3, value4)
.onDuplicateKeyUpdate()
.set(field1, value1)
.set(field2, value2)
.execute();
Modifier and Type | Method and Description |
---|---|
<T> InsertOnDuplicateSetMoreStep<R> |
set(Field<T> field,
Field<T> value)
Set values for
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause |
<T> InsertOnDuplicateSetMoreStep<R> |
set(Field<T> field,
T value)
Set values for
UPDATE in the INSERT statement's
ON DUPLICATE KEY UPDATE clause |
InsertOnDuplicateSetMoreStep<R> |
set(Map<? extends Field<?>,?> map)
Set multiple values for
UPDATE in the INSERT
statement's ON DUPLICATE KEY UPDATE clause
Please assure that key/value pairs have matching <T>
types. |
@Support(value={CUBRID,DB2,HSQLDB,MYSQL,ORACLE,SQLSERVER,SYBASE}) <T> InsertOnDuplicateSetMoreStep<R> set(Field<T> field, T value)
UPDATE
in the INSERT
statement's
ON DUPLICATE KEY UPDATE
clause@Support(value={CUBRID,DB2,HSQLDB,MYSQL,ORACLE,SQLSERVER,SYBASE}) <T> InsertOnDuplicateSetMoreStep<R> set(Field<T> field, Field<T> value)
UPDATE
in the INSERT
statement's
ON DUPLICATE KEY UPDATE
clause@Support(value={CUBRID,DB2,HSQLDB,MYSQL,ORACLE,SQLSERVER,SYBASE}) InsertOnDuplicateSetMoreStep<R> set(Map<? extends Field<?>,?> map)
UPDATE
in the INSERT
statement's ON DUPLICATE KEY UPDATE
clause
Please assure that key/value pairs have matching <T>
types. Values can either be of type <T>
or
Field<T>
Copyright © 2013. All Rights Reserved.