org.jooq
Interface InsertValuesStep<R extends Record>

All Superinterfaces:

Adapter, Attachable, Insert<R>, InsertFinalStep<R>, InsertOnDuplicateStep<R>, InsertReturningStep<R>, Query, QueryPart, Serializable

public interface InsertValuesStep<R extends Record>
extends InsertOnDuplicateStep<R>

This type is used for the 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();
 

Author:

Lukas Eder

Method Summary

Insert<R>	select(Select<?> select) Use a SELECT statement as the source of values for the INSERT statement This variant of the INSERT ..
InsertValuesStep<R>	values(Collection<?> values) Add values to the insert statement
InsertValuesStep<R>	values(Field<?>... values) Add values to the insert statement
InsertValuesStep<R>	values(Object... values) Add values to the insert statement

Methods inherited from interface org.jooq.InsertOnDuplicateStep

onDuplicateKeyIgnore, onDuplicateKeyUpdate

Methods inherited from interface org.jooq.Query

bind, bind, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable

Methods inherited from interface org.jooq.QueryPart

attach

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface org.jooq.InsertReturningStep

returning, returning, returning

Method Detail

values

InsertValuesStep<R> values(Object... values)

Add values to the insert statement

values

InsertValuesStep<R> values(Field<?>... values)

Add values to the insert statement

values

InsertValuesStep<R> values(Collection<?> values)

Add values to the insert statement

select

Insert<R> select(Select<?> select)

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

This variant of the INSERT .. SELECT statement expects a select returning exactly as many fields as specified previously in the INTO clause: FactoryOperations.insertInto(Table, Field...) or FactoryOperations.insertInto(Table, Collection)