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

Methods

Modifier and Type	Method and Description
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, cancel, close, execute, getBindValues, getParam, getParams, getSQL, getSQL, isExecutable, keepStatement, queryTimeout

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

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

Add values to the insert statement

values

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

Add values to the insert statement

values

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

Add values to the insert statement

select

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