Uses of Interface
org.jooq.Table
-
Packages that use Table Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes.org.jooq.util.postgres This package contains classes related to theSQLDialect.POSTGRES
dialect family. -
-
Uses of Table in org.jooq
Subinterfaces of Table in org.jooq Modifier and Type Interface Description interface
CommonTableExpression<R extends Record>
A common table expression.interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
Methods in org.jooq that return Table Modifier and Type Method Description Table<R>
VersionsBetweenAndStep. and(Field<? extends T> scn)
Add anAND
clause to the flashback versions query clause.Table<R>
VersionsBetweenAndStep. and(T scn)
Add anAND
clause to the flashback versions query clause.Table<R>
VersionsBetweenAndStep. andMaxvalue()
Add anAND MAXVALUE
clause to the flashback versions query clause.Table<R>
Table. as(String alias)
Create an alias for this table.Table<R>
Table. as(String alias, String... fieldAliases)
Create an alias for this table and its fields.Table<R>
Table. as(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(String alias, Function<? super Field<?>,? extends String> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Name alias)
Create an alias for this table.Table<R>
Table. as(Name alias, BiFunction<? super Field<?>,? super Integer,? extends Name> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Name alias, Function<? super Field<?>,? extends Name> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Name alias, Name... fieldAliases)
Create an alias for this table and its fields.Table<R>
Table. as(Table<?> otherTable)
Create an alias for this table based on another table's name.Table<R>
Table. as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Table<?> otherTable, Field<?>... otherFields)
Create an alias for this table based on another table's name.Table<R>
Table. asOfScn(Number scn)
Create anSQLDialect.ORACLE
flashback query clause from this table.Table<R>
Table. asOfScn(Field<? extends Number> scn)
Create anSQLDialect.ORACLE
flashback query clause from this table.Table<R>
Table. asOfTimestamp(Timestamp timestamp)
Create anSQLDialect.ORACLE
flashback query clause from this table.Table<R>
Table. asOfTimestamp(Field<Timestamp> timestamp)
Create anSQLDialect.ORACLE
flashback query clause from this table.Table<R>
TableLike. asTable()
The underlying table representation of this object.Table<R>
TableLike. asTable(String alias)
The underlying aliased table representation of this object.Table<R>
TableLike. asTable(String alias, String... fieldAliases)
The underlying aliased table representation of this object.Table<R>
TableLike. asTable(String alias, BiFunction<? super Field<?>,? super Integer,? extends String> aliasFunction)
The underlying aliased table representation of this object.Table<R>
TableLike. asTable(String alias, Function<? super Field<?>,? extends String> aliasFunction)
The underlying aliased table representation of this object.Table<R>
Table. at(String link)
A table reference of this table at a givenLink
.Table<R>
Table. at(Link link)
A table reference of this table at a givenLink
.Table<R>
Table. at(Name link)
A table reference of this table at a givenLink
.Table<Record>
Table. crossApply(String sql)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(String sql, Object... bindings)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(String sql, QueryPart... parts)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(Name name)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(SQL sql)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(TableLike<?> table)
CROSS APPLY
a table to this table.Table<Record>
Table. crossJoin(String sql)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(String sql, Object... bindings)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(String sql, QueryPart... parts)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(Name name)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(SQL sql)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(TableLike<?> table)
CROSS JOIN
a table to this table.Table<R>
Table. for_(PeriodSpecification periodSpecification)
Create a reference to a temporal table with aPeriodSpecification
for usage inSelect
.Table<R>
Table. forceIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. forceIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. forceIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. forceIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. forPortionOf(PeriodSpecification periodSpecification)
Table<R>
Check. getTable()
TheKey
's owner tableTable<R>
DAO. getTable()
Get the underlying table.Table<R>
Identity. getTable()
TheIDENTITY
's owner tableTable<?>
Index. getTable()
The table on which this index is defined.Table<R>
Key. getTable()
TheKey
's owner tableTable<?>
Schema. getTable(String name)
Get a table by its name (case-sensitive) in this schema, ornull
if no such table exists.Table<R>
TableField. getTable()
Table<R>
TableRecord. getTable()
The table from which this record was read.Table<R>
Table. ignoreIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. ignoreIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. ignoreIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. ignoreIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<Record>
PivotInStep. in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivotingTable<Record>
PivotInStep. in(Field<?>... fields)
Specify the acceptable values for pivotingTable<Record>
PivotInStep. in(T... values)
Specify the acceptable values for pivoting<R extends Record>
Table<R>DSLContext. map(Table<R> table)
Map a table to another one.<R extends Record>
Table<R>SchemaMapping. map(Table<R> table)
Deprecated.Apply mapping to a given tableTable<Record>
Table. naturalFullOuterJoin(String sql)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(String sql, Object... bindings)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(String sql, QueryPart... parts)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(Name name)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(SQL sql)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(TableLike<?> table)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalJoin(String sql)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(String sql, Object... bindings)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(String sql, QueryPart... parts)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(Name name)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(SQL sql)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(TableLike<?> table)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(String sql, Object... bindings)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(String sql, QueryPart... parts)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(String sql, Object... bindings)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(String sql, QueryPart... parts)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(SQL sql)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. outerApply(String sql)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(String sql, Object... bindings)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(String sql, QueryPart... parts)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(Name name)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(SQL sql)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(TableLike<?> table)
OUTER APPLY
a table to this table.Table<?>
Parser. parseTable(String sql)
Parse a SQL string to a table.Table<?>
Parser. parseTable(String sql, Object... bindings)
Parse a SQL string with bind variables to a table.Table<?>
QualifiedAsterisk. qualifier()
The qualifier.Table<Record>
DivideByReturningStep. returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividendTable<Record>
DivideByReturningStep. returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividendTable<R>
Table. useIndex(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. useIndexForGroupBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. useIndexForJoin(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<R>
Table. useIndexForOrderBy(String... indexes)
Specify a MySQL style table hint for query optimisation.Table<Record>
TableOnStep. using(Collection<? extends Field<?>> fields)
Join a table with theUSING(column [, column...])
syntax.Table<Record>
TableOnStep. using(Field<?>... fields)
Join a table with theUSING(column [, column...])
syntax.Table<R>
Table. where(String sql)
Add aWHERE
clause to the table.Table<R>
Table. where(String sql, Object... bindings)
Add aWHERE
clause to the table.Table<R>
Table. where(String sql, QueryPart... parts)
Add aWHERE
clause to the table.Table<R>
Table. where(Collection<? extends Condition> conditions)
Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Table<R>
Table. where(Condition condition)
Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Table<R>
Table. where(Condition... conditions)
Add aWHERE
clause to the table, connecting them with each other withOperator.AND
.Table<R>
Table. where(Field<Boolean> field)
Add aWHERE
clause to the table.Table<R>
Table. where(SQL sql)
Add aWHERE
clause to the table.Table<R>
Table. whereExists(Select<?> select)
Add aWHERE EXISTS
clause to the table.Table<R>
Table. whereNotExists(Select<?> select)
Add aWHERE NOT EXISTS
clause to the table.Table<R>
Table. with(String hint)
Specify a SQL Server style table hint for query optimisation.Methods in org.jooq that return types with arguments of type Table Modifier and Type Method Description List<Table<?>>
Meta. getTables()
Get all table objects from the underlying meta data source.List<Table<?>>
Meta. getTables(String name)
Get all table objects by name from the underlying meta data source.List<Table<?>>
Meta. getTables(Name name)
Get all table objects by name from the underlying meta data source.List<Table<?>>
Schema. getTables()
List all tables contained in this schema.Stream<Table<?>>
Schema. tableStream()
Stream all tables contained in this schema.Methods in org.jooq with parameters of type Table Modifier and Type Method Description void
SchemaMapping. add(Table<?> inputTable, String outputTable)
Deprecated.Add tables to this mappingvoid
SchemaMapping. add(Table<?> inputTable, Table<?> outputTable)
Deprecated.Add tables to this mappingAlterTableStep
DSLContext. alterTable(Table<?> table)
Create a new DSLALTER TABLE
statement.AlterTableStep
DSLContext. alterTableIfExists(Table<?> table)
Create a new DSLALTER TABLE
statement.AlterViewStep
DSLContext. alterView(Table<?> view)
Create a new DSLALTER VIEW
statement.AlterViewStep
DSLContext. alterViewIfExists(Table<?> view)
Create a new DSLALTER VIEW
statement.Table<R>
Table. as(Table<?> otherTable)
Create an alias for this table based on another table's name.Table<R>
Table. as(Table<?> otherTable, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Table<?> otherTable, Function<? super Field<?>,? extends Field<?>> aliasFunction)
Create an alias for this table and its fields.Table<R>
Table. as(Table<?> otherTable, Field<?>... otherFields)
Create an alias for this table based on another table's name.<X extends Record>
ResultQuery<X>ResultQuery. coerce(Table<X> table)
Coerce the result record type of this query to that of a table.CommentOnIsStep
DSLContext. commentOnTable(Table<?> table)
Create a new DSLCOMMENT ON TABLE
statement.CommentOnIsStep
DSLContext. commentOnView(Table<?> view)
Create a new DSLCOMMENT ON VIEW
statement.CreateTableColumnStep
DSLContext. createGlobalTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateTableColumnStep
DSLContext. createTable(Table<?> table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
DSLContext. createTableIfNotExists(Table<?> table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
DSLContext. createTemporaryTable(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.CreateTableColumnStep
DSLContext. createTemporaryTableIfNotExists(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE IF NOT EXISTS
statement.CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.Queries
DSLContext. ddl(Table<?> table)
Convenience method forMeta.ddl()
.Queries
DSLContext. ddl(Table<?>... tables)
Convenience method forMeta.ddl()
.Queries
DSLContext. ddl(Table<?>[] tables, DDLExportConfiguration configuration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
DSLContext. ddl(Table<?>[] tables, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
DSLContext. ddl(Table<?> table, DDLExportConfiguration configuration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
DSLContext. ddl(Table<?> table, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
.<R extends Record>
DeleteUsingStep<R>DSLContext. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>WithStep. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DSLContext. deleteFrom(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DSLContext. deleteQuery(Table<R> table)
Create a newDeleteQuery
DivideByOnStep
Table. divideBy(Table<?> divisor)
Create a newTABLE
reference from this table, applying relational division.DropTableStep
DSLContext. dropTable(Table<?> table)
Create a new DSLDROP TABLE
statement.DropTableStep
DSLContext. dropTableIfExists(Table<?> table)
Create a new DSLDROP TABLE IF EXISTS
statement.DropTableStep
DSLContext. dropTemporaryTable(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE
statement.DropTableStep
DSLContext. dropTemporaryTableIfExists(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE IF EXISTS
statement.DropViewFinalStep
DSLContext. dropView(Table<?> view)
Create a new DSLDROP VIEW
statement.DropViewFinalStep
DSLContext. dropViewIfExists(Table<?> view)
Create a new DSLDROP VIEW IF EXISTS
statement.Condition
Table. eq(Table<R> table)
Create a predicate comparing records from self-joined tables.Condition
Table. equal(Table<R> table)
Create a predicate comparing records from self-joined tables.<R extends Record>
Result<R>DSLContext. fetch(Table<R> table)
Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Condition condition)
Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Condition... conditions)
Execute and return all records for<R extends Record>
RDSLContext. fetchAny(Table<R> table)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
ZResultQuery. fetchAnyInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition... conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Collection<? extends Condition> condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition... condition)
Execute and return all records asynchronously forint
DSLContext. fetchCount(Table<?> table)
Count the number of records in a table.int
DSLContext. fetchCount(Table<?> table, Collection<? extends Condition> conditions)
Count the number of records in a table that satisfy a condition.int
DSLContext. fetchCount(Table<?> table, Condition condition)
Count the number of records in a table that satisfy a condition.int
DSLContext. fetchCount(Table<?> table, Condition... conditions)
Count the number of records in a table that satisfy a condition.boolean
DSLContext. fetchExists(Table<?> table)
Check if a table has any records.boolean
DSLContext. fetchExists(Table<?> table, Collection<? extends Condition> conditions)
Check if a table has any records that satisfy a condition.boolean
DSLContext. fetchExists(Table<?> table, Condition condition)
Check if a table has any records that satisfy a condition.boolean
DSLContext. fetchExists(Table<?> table, Condition... conditions)
Check if a table has any records that satisfy a condition.<S extends Record>
Map<S,Result<R>>ResultQuery. fetchGroups(Table<S> table)
Execute the query and return aMap
with the result grouped by the given table.<E,S extends Record>
Map<S,List<E>>ResultQuery. fetchGroups(Table<S> table, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.<E,S extends Record>
Map<S,List<E>>ResultQuery. fetchGroups(Table<S> table, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.<S extends Record,T extends Record>
Map<S,Result<T>>ResultQuery. fetchGroups(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with the result grouped by the given table.<Z extends Record>
Result<Z>Cursor. fetchInto(Table<Z> table)
Map resulting records onto a custom record.<Z extends Record>
Result<Z>ResultQuery. fetchInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table)
Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition... conditions)
Execute and return all records lazily for<S extends Record>
Map<S,R>ResultQuery. fetchMap(Table<S> table)
Execute the query and return aMap
with table as a map key and the corresponding record as value.<E,S extends Record>
Map<S,E>ResultQuery. fetchMap(Table<S> table, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.<E,S extends Record>
Map<S,E>ResultQuery. fetchMap(Table<S> table, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.<S extends Record,T extends Record>
Map<S,T>ResultQuery. fetchMap(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with table as a map key and the corresponding record as value.<Z extends Record>
ZCursor. fetchNextInto(Table<Z> table)
Map the next resulting record onto a custom record.<Z extends Record>
Optional<Z>Cursor. fetchNextOptionalInto(Table<Z> table)
Map the next resulting record onto a custom record.<R extends Record>
RDSLContext. fetchOne(Table<R> table)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
ZCursor. fetchOneInto(Table<Z> table)
Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)
instead.<Z extends Record>
ZResultQuery. fetchOneInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table)
Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
Optional<Z>Cursor. fetchOptionalInto(Table<Z> table)
Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.<Z extends Record>
Optional<Z>ResultQuery. fetchOptionalInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
RDSLContext. fetchSingle(Table<R> table)
Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Collection<? extends Condition> conditions)
Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Condition condition)
Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Condition... conditions)
Execute and return exactly one record for<Z extends Record>
ZResultQuery. fetchSingleInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table)
Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Condition... conditions)
Execute and return all records lazily for<Z extends Record>
Stream<Z>ResultQuery. fetchStreamInto(Table<Z> table)
Stream this query, mapping records into a custom record.<T> T
DSLContext. fetchValue(Table<? extends Record1<T>> table)
Fetch a single value from a single column table.<T> List<T>
DSLContext. fetchValues(Table<? extends Record1<T>> table)
Fetch all values from a single column table.void
Formattable. formatInsert(OutputStream stream, Table<?> table, Field<?>... fields)
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anOutputStream
.void
Formattable. formatInsert(Writer writer, Table<?> table, Field<?>... fields)
LikeFormattable.formatInsert(Table, Field...)
, but the data is output onto anWriter
.String
Formattable. formatInsert(Table<?> table, Field<?>... fields)
Get this result as a set ofINSERT
statements.<O extends Record>
List<ForeignKey<O,R>>Table. getReferencesFrom(Table<O> other)
Get a list ofFOREIGN KEY
's of a specific table, referencing a this table.<O extends Record>
List<ForeignKey<R,O>>Table. getReferencesTo(Table<O> other)
Get a list ofFOREIGN KEY
's of this table, referencing a specific table.InformationSchema
DSLContext. informationSchema(Table<?> table)
Convenience method forMeta.informationSchema()
.InformationSchema
DSLContext. informationSchema(Table<?>... table)
Convenience method forMeta.informationSchema()
.<R extends Record>
InsertSetStep<R>DSLContext. insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>DSLContext. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.<R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSLContext. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record>
InsertSetStep<R>WithStep. insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>WithStep. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.<R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>WithStep. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record>
InsertQuery<R>DSLContext. insertQuery(Table<R> into)
Create a newInsertQuery
<R extends Record>
RRecord. into(Table<R> table)
Map resulting records onto a custom record type.<Z extends Record>
Result<Z>Result. into(Table<Z> table)
Map resulting records onto a custom record.SelectFromStep<Record>
SelectIntoStep. into(Table<?> table)
Add anINTO
clause to theSELECT
statement.<S extends Record>
Map<S,Result<R>>Result. intoGroups(Table<S> table)
Return aMap
with the result grouped by the given key table.<E,S extends Record>
Map<S,List<E>>Result. intoGroups(Table<S> table, Class<? extends E> type)
Return aMap
with results grouped by the given key table and mapped into the given entity type.<E,S extends Record>
Map<S,List<E>>Result. intoGroups(Table<S> table, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given key table and mapped into the given entity type.<S extends Record,T extends Record>
Map<S,Result<T>>Result. intoGroups(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the result grouped by the given key table.<S extends Record>
Map<S,R>Result. intoMap(Table<S> table)
Return aMap
with the given key table as a map key and the corresponding record as value.<E,S extends Record>
Map<S,E>Result. intoMap(Table<S> table, Class<? extends E> type)
Return aMap
with results grouped by the given key table and mapped into the given entity type.<E,S extends Record>
Map<S,E>Result. intoMap(Table<S> table, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given key table and mapped by the given mapper.<S extends Record,T extends Record>
Map<S,T>Result. intoMap(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the given key table as a map key and the corresponding record as value.<R extends Record>
LoaderOptionsStep<R>DSLContext. loadInto(Table<R> table)
Create a newLoader
object to load data from a CSV or XML source.<R extends Record>
Table<R>DSLContext. map(Table<R> table)
Map a table to another one.<R extends Record>
Table<R>SchemaMapping. map(Table<R> table)
Deprecated.Apply mapping to a given table<R extends Record>
MergeUsingStep<R>DSLContext. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Field<?>... fields)
<R extends Record,T1>
MergeKeyStep1<R,T1>DSLContext. mergeInto(Table<R> table, Field<T1> field1)
<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
<R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record>
MergeUsingStep<R>WithStep. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1>
MergeKeyStep1<R,T1>WithStep. mergeInto(Table<R> table, Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>WithStep. mergeInto(Table<R> table, 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)
Create a new DSL merge statement (H2-specific syntax).Meta
DSLContext. meta(Table<?>... tables)
Access the database meta data from explicit table information.Condition
Table. ne(Table<R> table)
Create a predicate comparing records from self-non-equi-joined tables.<R extends Record>
RDSLContext. newRecord(Table<R> table)
Create a newRecord
that can be inserted into the corresponding table.<R extends Record>
RDSLContext. newRecord(Table<R> table, Object source)
Create a new pre-filledRecord
that can be inserted into the corresponding table.<R extends Record>
Result<R>DSLContext. newResult(Table<R> table)
Create a new emptyResult
.Condition
Table. notEqual(Table<R> table)
Create a predicate comparing records from self-non-equi-joined tables.SelectForUpdateWaitStep<R>
SelectForUpdateOfStep. of(Table<?>... tables)
Add anOF
clause to theFOR UPDATE
clause at the end of the query.AlterIndexStep
AlterIndexOnStep. on(Table<?> table)
Specify the table expression on which to alter an index.CreateIndexIncludeStep
CreateIndexStep. on(Table<?> table, Collection<? extends OrderField<?>> fields)
Specify the table and column expressions on which to create an index.CreateIndexIncludeStep
CreateIndexStep. on(Table<?> table, OrderField<?>... fields)
Specify the table and column expressions on which to create an index.DropIndexCascadeStep
DropIndexOnStep. on(Table<?> table)
Specify the table expression on which to drop an index.GrantToStep
GrantOnStep. on(Table<?> table)
Grant a privilege on a table.RevokeFromStep
RevokeOnStep. on(Table<?> table)
Revoke a privilege on a table.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1. references(Table<?> table, Field<T1> field1)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep2. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep2. references(Table<?> table, Field<T1> field1, Field<T2> field2)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3. references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4. references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5. references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6. references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7. references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8. references(Table<?> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9. references(Table<?> table, 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)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN. references(Table<?> table)
Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN. references(Table<?> table, Field<?>... fields)
Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.AlterTableFinalStep
AlterTableStep. renameTo(Table<?> newName)
Add aRENAME TO
clause to theALTER TABLE
statement.AlterViewFinalStep
AlterViewStep. renameTo(Table<?> newName)
Add aRENAME TO
clause to theALTER VIEW
statement.<R extends Record>
SelectWhereStep<R>DSLContext. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectWhereStep<R>WithStep. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.void
SelectQuery. setForUpdateOf(Table<?>... tables)
Some RDBMS allow for specifying the tables that should be locked by theFOR UPDATE
clause, instead of the full row.void
SelectQuery. setInto(Table<?> table)
AddINTO
clause to theSELECT
statement.<R extends Record>
TruncateIdentityStep<R>DSLContext. truncate(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>DSLContext. truncateTable(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>DSLContext. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateSetFirstStep<R>WithStep. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DSLContext. updateQuery(Table<R> table)
Create a newUpdateQuery
Method parameters in org.jooq with type arguments of type Table Modifier and Type Method Description Queries
DSLContext. ddl(Collection<? extends Table<?>> tables)
Convenience method forMeta.ddl()
.Queries
DSLContext. ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration configuration)
Convenience method forMeta.ddl(DDLExportConfiguration)
.Queries
DSLContext. ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)
Convenience method forMeta.ddl(DDLExportConfiguration)
. -
Uses of Table in org.jooq.impl
Classes in org.jooq.impl that implement Table Modifier and Type Class Description class
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
TableImpl<R extends Record>
A common base type for tablesMethods in org.jooq.impl that return Table Modifier and Type Method Description Table<R>
TableImpl. as(Name as)
Subclasses may override this method to provide custom aliasing implementationsTable<R>
TableImpl. as(Name as, Name... fieldAliases)
Subclasses may override this method to provide custom aliasing implementationsstatic Table<Record>
DSL. dual()
TheDUAL
table to be used for syntactic completeness.static Table<Record1<Integer>>
DSL. generateSeries(int from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
DSL. generateSeries(int from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(int from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(int from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
DSL. generateSeries(int from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(int from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, int to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, int to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, int to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, Field<Integer> to)
A table function generating a series of values fromfrom
toto
(inclusive).static Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, Field<Integer> to, int step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static Table<Record1<Integer>>
DSL. generateSeries(Field<Integer> from, Field<Integer> to, Field<Integer> step)
A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.Table<R>
DAOImpl. getTable()
Table<?>
SchemaImpl. getTable(String tableName)
Table<R>
TableRecordImpl. getTable()
static <R extends Record>
Table<R>DSL. lateral(TableLike<R> table)
Create aLATERAL
joined table.<R extends Record>
Table<R>DefaultDSLContext. map(Table<R> table)
Table<R>
TableImpl. rename(String rename)
Table<R>
TableImpl. rename(Name rename)
static Table<Record>
DSL. rowsFrom(Table<?>... tables)
Create aROWS FROM (tables...)
expression.static Table<?>
DSL. table(Object[] array)
A synonym forDSL.unnest(Object[])
.static Table<Record>
DSL. table(String sql)
A custom SQL clause that can render arbitrary table expressions.static Table<Record>
DSL. table(String sql, Object... bindings)
A custom SQL clause that can render arbitrary table expressions.static Table<Record>
DSL. table(String sql, QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.static Table<?>
DSL. table(Collection<?> list)
A synonym forDSL.unnest(Collection)
.static Table<?>
DSL. table(ArrayRecord<?> array)
A synonym forDSL.unnest(ArrayRecord)
.static Table<?>
DSL. table(Field<?> cursor)
A synonym forDSL.unnest(Field)
.static Table<Record>
DSL. table(Name name)
Create a qualified table, given its table name.static Table<Record>
DSL. table(Name name, Comment comment)
Create a qualified table, given its table name.static <R extends Record>
Table<R>DSL. table(Result<R> result)
Use a previously obtained result as a newTable
that can be used in SQL statements throughDSL.values(RowN...)
.static <R extends Record>
Table<R>DSL. table(Select<R> select)
A synonym forTableLike.asTable()
, which might look a bit more fluent like this, to some users.static Table<Record>
DSL. table(SQL sql)
A custom SQL clause that can render arbitrary table expressions.static <R extends Record>
Table<R>DSL. table(R record)
Use a previously obtained record as a new Tablestatic <R extends Record>
Table<R>DSL. table(R... records)
Use a previously obtained set of records as a new Tablestatic Table<Record>
DSL. tableByName(String... qualifiedName)
Deprecated.- [#3843] - 3.6.0 - useDSL.table(Name)
insteadstatic Table<?>
DSL. unnest(Object[] array)
Create a table from an array of values.static Table<?>
DSL. unnest(Collection<?> list)
Create a table from a list of values.static Table<?>
DSL. unnest(ArrayRecord<?> array)
Create a table from an array of values.static Table<?>
DSL. unnest(Field<?> cursor)
Create a table from a field.static <T1> Table<Record1<T1>>
DSL. values(Row1<T1>... rows)
Create aVALUES()
expression of degree1
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Table<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>DSL. values(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
Create aVALUES()
expression of degree10
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Table<Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>>DSL. values(Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>... rows)
Create aVALUES()
expression of degree11
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Table<Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>>DSL. values(Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>... rows)
Create aVALUES()
expression of degree12
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Table<Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>>DSL. values(Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>... rows)
Create aVALUES()
expression of degree13
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Table<Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>>DSL. values(Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>... rows)
Create aVALUES()
expression of degree14
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Table<Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>>DSL. values(Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>... rows)
Create aVALUES()
expression of degree15
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Table<Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>>DSL. values(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows)
Create aVALUES()
expression of degree16
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Table<Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>>DSL. values(Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>... rows)
Create aVALUES()
expression of degree17
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Table<Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>>DSL. values(Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>... rows)
Create aVALUES()
expression of degree18
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Table<Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>>DSL. values(Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>... rows)
Create aVALUES()
expression of degree19
.static <T1,T2>
Table<Record2<T1,T2>>DSL. values(Row2<T1,T2>... rows)
Create aVALUES()
expression of degree2
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
Table<Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>>DSL. values(Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>... rows)
Create aVALUES()
expression of degree20
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
Table<Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>>DSL. values(Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>... rows)
Create aVALUES()
expression of degree21
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
Table<Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>>DSL. values(Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>... rows)
Create aVALUES()
expression of degree22
.static <T1,T2,T3>
Table<Record3<T1,T2,T3>>DSL. values(Row3<T1,T2,T3>... rows)
Create aVALUES()
expression of degree3
.static <T1,T2,T3,T4>
Table<Record4<T1,T2,T3,T4>>DSL. values(Row4<T1,T2,T3,T4>... rows)
Create aVALUES()
expression of degree4
.static <T1,T2,T3,T4,T5>
Table<Record5<T1,T2,T3,T4,T5>>DSL. values(Row5<T1,T2,T3,T4,T5>... rows)
Create aVALUES()
expression of degree5
.static <T1,T2,T3,T4,T5,T6>
Table<Record6<T1,T2,T3,T4,T5,T6>>DSL. values(Row6<T1,T2,T3,T4,T5,T6>... rows)
Create aVALUES()
expression of degree6
.static <T1,T2,T3,T4,T5,T6,T7>
Table<Record7<T1,T2,T3,T4,T5,T6,T7>>DSL. values(Row7<T1,T2,T3,T4,T5,T6,T7>... rows)
Create aVALUES()
expression of degree7
.static <T1,T2,T3,T4,T5,T6,T7,T8>
Table<Record8<T1,T2,T3,T4,T5,T6,T7,T8>>DSL. values(Row8<T1,T2,T3,T4,T5,T6,T7,T8>... rows)
Create aVALUES()
expression of degree8
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Table<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>DSL. values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows)
Create aVALUES()
expression of degree9
.static Table<Record>
DSL. values(RowN... rows)
Create aVALUES()
expression of arbitrary degree.Methods in org.jooq.impl that return types with arguments of type Table Modifier and Type Method Description List<Table<?>>
SchemaImpl. getTables()
List all tables contained in this schema.Stream<Table<?>>
SchemaImpl. tableStream()
Methods in org.jooq.impl with parameters of type Table Modifier and Type Method Description AlterTableStep
DefaultDSLContext. alterTable(Table<?> table)
static AlterTableStep
DSL. alterTable(Table<?> table)
Create a new DSLALTER TABLE
statement.AlterTableStep
DefaultDSLContext. alterTableIfExists(Table<?> table)
static AlterTableStep
DSL. alterTableIfExists(Table<?> table)
Create a new DSLALTER TABLE
statement.AlterViewStep
DefaultDSLContext. alterView(Table<?> table)
static AlterViewStep
DSL. alterView(Table<?> view)
Create a new DSLALTER VIEW
statement.AlterViewStep
DefaultDSLContext. alterViewIfExists(Table<?> table)
static AlterViewStep
DSL. alterViewIfExists(Table<?> view)
Create a new DSLALTER VIEW
statement.CommentOnIsStep
DefaultDSLContext. commentOnTable(Table<?> table)
static CommentOnIsStep
DSL. commentOnTable(Table<?> table)
Create a new DSLCOMMENT ON TABLE
statement.CommentOnIsStep
DefaultDSLContext. commentOnView(Table<?> view)
static CommentOnIsStep
DSL. commentOnView(Table<?> view)
Create a new DSLCOMMENT ON VIEW
statement.static AggregateFunction<Integer>
DSL. count(Table<?> table)
Get the count(table) function.static AggregateFunction<Integer>
DSL. countDistinct(Table<?> table)
Get the count(distinct table) function.static <R extends Record>
Check<R>Internal. createCheck(Table<R> table, Name name, String condition)
Factory method for check constraints.static <R extends Record>
Check<R>Internal. createCheck(Table<R> table, Name name, String condition, boolean enforced)
Factory method for check constraints.static <R extends Record,T extends Record>
TableField<R,T>Internal. createEmbeddable(Name name, Class<T> recordType, Table<R> table, TableField<R,?>... fields)
Factory method for embeddable types.static <R extends Record,U extends Record>
ForeignKey<R,U>AbstractKeys. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U>AbstractKeys. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Factory method for foreign keys.CreateTableColumnStep
DefaultDSLContext. createGlobalTemporaryTable(Table<?> table)
static CreateTableColumnStep
DSL. createGlobalTemporaryTable(Table<?> table)
Create a new DSLCREATE GLOBAL TEMPORARY TABLE
statement.static <R extends Record,T>
Identity<R,T>AbstractKeys. createIdentity(Table<R> table, TableField<R,T> field)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,T>
Identity<R,T>Internal. createIdentity(Table<R> table, TableField<R,T> field)
Factory method for identities.static Index
AbstractKeys. createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic Index
Internal. createIndex(String name, Table<?> table, OrderField<?>[] sortFields, boolean unique)
Factory method for indexes.static Index
Internal. createIndex(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique)
Factory method for indexes.CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)
static CreateViewAsStep
DSL. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.static CreateViewAsStep
DSL. createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.static Name
Internal. createPathAlias(Table<?> child, ForeignKey<?,?> path)
Factory method for path aliases.CreateTableColumnStep
DefaultDSLContext. createTable(Table<?> table)
static CreateTableColumnStep
DSL. createTable(Table<?> table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
DefaultDSLContext. createTableIfNotExists(Table<?> table)
static CreateTableColumnStep
DSL. createTableIfNotExists(Table<?> table)
Create a new DSLCREATE TABLE
statement.CreateTableColumnStep
DefaultDSLContext. createTemporaryTable(Table<?> table)
static CreateTableColumnStep
DSL. createTemporaryTable(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.CreateTableColumnStep
DefaultDSLContext. createTemporaryTableIfNotExists(Table<?> table)
static CreateTableColumnStep
DSL. createTemporaryTableIfNotExists(Table<?> table)
Create a new DSLCREATE TEMPORARY TABLE
statement.static <R extends Record>
UniqueKey<R>AbstractKeys. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record>
UniqueKey<R>AbstractKeys. createUniqueKey(Table<R> table, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Factory method for unique keys.static <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Factory method for unique keys.static <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, TableField<R,?>... fields)
Factory method for unique keys.CreateViewAsStep<Record>
DefaultDSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Table<?> view, Field<?>... fields)
static CreateViewAsStep
DSL. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.static CreateViewAsStep
DSL. createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)
static CreateViewAsStep
DSL. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.static CreateViewAsStep
DSL. createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW IF NOT EXISTS
statement.Queries
DefaultDSLContext. ddl(Table... tables)
Queries
DefaultDSLContext. ddl(Table[] tables, DDLExportConfiguration exportConfiguration)
Queries
DefaultDSLContext. ddl(Table[] tables, DDLFlag... flags)
Queries
DefaultDSLContext. ddl(Table<?> table)
Queries
DefaultDSLContext. ddl(Table<?> table, DDLExportConfiguration exportConfiguration)
Queries
DefaultDSLContext. ddl(Table<?> table, DDLFlag... flags)
<R extends Record>
DeleteUsingStep<R>DefaultDSLContext. delete(Table<R> table)
static <R extends Record>
DeleteUsingStep<R>DSL. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DefaultDSLContext. deleteFrom(Table<R> table)
static <R extends Record>
DeleteUsingStep<R>DSL. deleteFrom(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DefaultDSLContext. deleteQuery(Table<R> table)
DropTableStep
DefaultDSLContext. dropTable(Table<?> table)
static DropTableStep
DSL. dropTable(Table<?> table)
Create a new DSLDROP TABLE
statement.DropTableStep
DefaultDSLContext. dropTableIfExists(Table<?> table)
static DropTableStep
DSL. dropTableIfExists(Table<?> table)
Create a new DSLDROP TABLE IF EXISTS
statement.DropTableStep
DefaultDSLContext. dropTemporaryTable(Table<?> table)
static DropTableStep
DSL. dropTemporaryTable(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE
statement.DropTableStep
DefaultDSLContext. dropTemporaryTableIfExists(Table<?> table)
static DropTableStep
DSL. dropTemporaryTableIfExists(Table<?> table)
Create a new DSLDROP TEMPORARY TABLE IF EXISTS
statement.DropViewFinalStep
DefaultDSLContext. dropView(Table<?> view)
static DropViewFinalStep
DSL. dropView(Table<?> view)
Create a new DSLDROP VIEW
statement.DropViewFinalStep
DefaultDSLContext. dropViewIfExists(Table<?> view)
static DropViewFinalStep
DSL. dropViewIfExists(Table<?> view)
Create a new DSLDROP VIEW IF EXISTS
statement.<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Condition condition)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Condition... conditions)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Condition... conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table, Condition condition)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table, Condition... conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table, Condition condition)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table, Condition... conditions)
int
DefaultDSLContext. fetchCount(Table<?> table)
int
DefaultDSLContext. fetchCount(Table<?> table, Collection<? extends Condition> conditions)
int
DefaultDSLContext. fetchCount(Table<?> table, Condition condition)
int
DefaultDSLContext. fetchCount(Table<?> table, Condition... conditions)
boolean
DefaultDSLContext. fetchExists(Table<?> table)
boolean
DefaultDSLContext. fetchExists(Table<?> table, Collection<? extends Condition> conditions)
boolean
DefaultDSLContext. fetchExists(Table<?> table, Condition condition)
boolean
DefaultDSLContext. fetchExists(Table<?> table, Condition... conditions)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Condition condition)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Condition... conditions)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Condition... conditions)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Condition condition)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Condition... conditions)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table, Condition... conditions)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Condition condition)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Condition... conditions)
<T> T
DefaultDSLContext. fetchValue(Table<? extends Record1<T>> table)
<T> List<T>
DefaultDSLContext. fetchValues(Table<? extends Record1<T>> table)
void
ArrayRecordImpl. formatInsert(Writer writer, Table<?> table, Field<?>... fields)
InformationSchema
DefaultDSLContext. informationSchema(Table<?> table)
InformationSchema
DefaultDSLContext. informationSchema(Table<?>... tables)
<R extends Record>
InsertSetStep<R>DefaultDSLContext. insertInto(Table<R> into)
<R extends Record>
InsertValuesStepN<R>DefaultDSLContext. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
<R extends Record>
InsertValuesStepN<R>DefaultDSLContext. insertInto(Table<R> into, Field<?>... fields)
<R extends Record,T1>
InsertValuesStep1<R,T1>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1)
<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
<R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DefaultDSLContext. insertInto(Table<R> into, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DefaultDSLContext. insertInto(Table<R> into, 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)
static <R extends Record>
InsertSetStep<R>DSL. insertInto(Table<R> into)
Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>DSL. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>DSL. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.static <R extends Record,T1>
InsertValuesStep1<R,T1>DSL. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.static <R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSL. insertInto(Table<R> into, 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)
Create a new DSL insert statement.<R extends Record>
InsertQuery<R>DefaultDSLContext. insertQuery(Table<R> into)
<R extends Record>
LoaderOptionsStep<R>DefaultDSLContext. loadInto(Table<R> table)
<R extends Record>
Table<R>DefaultDSLContext. map(Table<R> table)
<R extends Record>
MergeUsingStep<R>DefaultDSLContext. mergeInto(Table<R> table)
<R extends Record>
MergeKeyStepN<R>DefaultDSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
<R extends Record>
MergeKeyStepN<R>DefaultDSLContext. mergeInto(Table<R> table, Field<?>... fields)
<R extends Record,T1>
MergeKeyStep1<R,T1>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1)
<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
<R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DefaultDSLContext. mergeInto(Table<R> table, 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)
static <R extends Record>
MergeUsingStep<R>DSL. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.static <R extends Record>
MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).static <R extends Record>
MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).static <R extends Record,T1>
MergeKeyStep1<R,T1>DSL. mergeInto(Table<R> table, Field<T1> field1)
static <R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
static <R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
static <R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
static <R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
static <R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSL. mergeInto(Table<R> table, 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)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSL. mergeInto(Table<R> table, 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)
Meta
DefaultDSLContext. meta(Table<?>... tables)
<R extends Record>
RDefaultDSLContext. newRecord(Table<R> table)
<R extends Record>
RDefaultDSLContext. newRecord(Table<R> table, Object source)
<R extends Record>
Result<R>DefaultDSLContext. newResult(Table<R> table)
static Table<Record>
DSL. rowsFrom(Table<?>... tables)
Create aROWS FROM (tables...)
expression.<R extends Record>
SelectWhereStep<R>DefaultDSLContext. selectFrom(Table<R> table)
static <R extends Record>
SelectWhereStep<R>DSL. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext. truncate(Table<R> table)
static <R extends Record>
TruncateIdentityStep<R>DSL. truncate(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext. truncateTable(Table<R> table)
static <R extends Record>
TruncateIdentityStep<R>DSL. truncateTable(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>DefaultDSLContext. update(Table<R> table)
static <R extends Record>
UpdateSetFirstStep<R>DSL. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DefaultDSLContext. updateQuery(Table<R> table)
Method parameters in org.jooq.impl with type arguments of type Table Modifier and Type Method Description Queries
DefaultDSLContext. ddl(Collection<? extends Table<?>> tables)
Queries
DefaultDSLContext. ddl(Collection<? extends Table<?>> tables, DDLExportConfiguration exportConfiguration)
Queries
DefaultDSLContext. ddl(Collection<? extends Table<?>> tables, DDLFlag... flags)
Constructors in org.jooq.impl with parameters of type Table Constructor Description CustomRecord(Table<R> table)
DAOImpl(Table<R> table, Class<P> type)
DAOImpl(Table<R> table, Class<P> type, Configuration configuration)
TableImpl(String name, Schema schema, Table<R> aliased)
Deprecated.- 3.10 - [#5996] - UseTableImpl(Name, Schema, Table)
instead (or re-generated your code).TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters)
Deprecated.- 3.10 - [#5996] - UseTableImpl(Name, Schema, Table, Field[])
instead (or re-generated your code).TableImpl(String name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)
Deprecated.- 3.10 - [#5996] - UseTableImpl(Name, Schema, Table, Field[], String)
instead (or re-generated your code).TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment)
TableImpl(Name name, Schema schema, Table<?> child, ForeignKey<?,R> path, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)
TableImpl(Name name, Schema schema, Table<R> aliased)
TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters)
TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, String comment)
Deprecated.- 3.11 - [#7027] - UseTableImpl(Name, Schema, Table, Field[], Comment)
instead.TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment)
TableImpl(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options)
TableImpl(Table<?> child, ForeignKey<?,R> path, Table<R> parent)
TableMetaProvider(Configuration configuration, Table<?>... tables)
TableRecordImpl(Table<R> table)
UpdatableRecordImpl(Table<R> table)
-
Uses of Table in org.jooq.util.postgres
Methods in org.jooq.util.postgres that return Table Modifier and Type Method Description static Table<Record>
PostgresDSL. only(Table<?> table)
Get the PostgreSQL-specificONLY [table]
clause for use with table inheritance.Methods in org.jooq.util.postgres with parameters of type Table Modifier and Type Method Description static Field<Long>
PostgresDSL. oid(Table<?> table)
Get the PostgreSQL-specific[table].oid
column from any table.static Table<Record>
PostgresDSL. only(Table<?> table)
Get the PostgreSQL-specificONLY [table]
clause for use with table inheritance.
-