public interface UpdateFromStep<R extends Record> extends UpdateWhereStep<R>
Update
's DSL API.
Example:
DSLContext create = DSL.using(configuration);
create.update(table)
.set(field1, value1)
.set(field2, value2)
.where(field1.greaterThan(100))
.execute();
Modifier and Type | Method and Description |
---|---|
UpdateWhereStep<R> |
from(Collection<? extends TableLike<?>> tables)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(Name name)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(SQL sql)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(String sql)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(String sql,
Object... bindings)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(String sql,
QueryPart... parts)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(TableLike<?>... table)
Add a
FROM clause to the query. |
UpdateWhereStep<R> |
from(TableLike<?> table)
Add a
FROM clause to the query. |
where, where, where, where, where, where, where, where, whereExists, whereNotExists
bind, bind, cancel, close, execute, executeAsync, executeAsync, getBindValues, getParam, getParams, getSQL, getSQL, getSQL, isExecutable, keepStatement, queryTimeout
attach, detach
returning, returning, returning
@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) UpdateWhereStep<R> from(TableLike<?> table)
FROM
clause to the query.@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) UpdateWhereStep<R> from(TableLike<?>... table)
FROM
clause to the query.@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) UpdateWhereStep<R> from(Collection<? extends TableLike<?>> tables)
FROM
clause to the query.@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) @PlainSQL UpdateWhereStep<R> from(SQL sql)
FROM
clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.table(SQL)
,
SQL
@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) @PlainSQL UpdateWhereStep<R> from(String sql)
FROM
clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
DSL.table(String)
,
SQL
@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) @PlainSQL UpdateWhereStep<R> from(String sql, Object... bindings)
FROM
clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
@Support(value={HANA,INGRES,POSTGRES,SQLSERVER,SYBASE}) @PlainSQL UpdateWhereStep<R> from(String sql, QueryPart... parts)
FROM
clause to the query.
NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
Copyright © 2017. All Rights Reserved.