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

onDuplicateKeyUpdate

Methods inherited from interface org.jooq.Query

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

Methods inherited from interface org.jooq.Attachable

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)