| Package | Description | 
|---|---|
| org.jooq | 
 The  
org.jooq package contains jOOQ's public API. | 
| org.jooq.impl | 
 The  
org.jooq.impl package contains jOOQ's implementation classes. | 
| Modifier and Type | Method and Description | 
|---|---|
<T1,T2,T3,T4,T5,T6> | 
Record.into(Field<T1> field1,
    Field<T2> field2,
    Field<T3> field3,
    Field<T4> field4,
    Field<T5> field5,
    Field<T6> field6)
Copy this record into a new record holding only a subset of the previous
 fields. 
 | 
<T1,T2,T3,T4,T5,T6> | 
DSLContext.newRecord(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         Field<T5> field5,
         Field<T6> field6)
Create a new empty  
Record. | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.value1(T1 value)
Set the first value. 
 | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.value2(T2 value)
Set the second value. 
 | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.value3(T3 value)
Set the third value. 
 | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.value4(T4 value)
Set the fourth value. 
 | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.value5(T5 value)
Set the fifth value. 
 | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.value6(T6 value)
Set the sixth value. 
 | 
Record6<T1,T2,T3,T4,T5,T6> | 
Record6.values(T1 t1,
      T2 t2,
      T3 t3,
      T4 t4,
      T5 t5,
      T6 t6)
Set all values. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
<T1,T2,T3,T4,T5,T6> | 
Result.into(Field<T1> field1,
    Field<T2> field2,
    Field<T3> field3,
    Field<T4> field4,
    Field<T5> field5,
    Field<T6> field6)
Copy all records from this result into a new result with new records
 holding only a subset of the previous fields. 
 | 
<T1,T2,T3,T4,T5,T6> | 
DSLContext.newResult(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         Field<T5> field5,
         Field<T6> field6)
Create a new empty  
Result. | 
<T1,T2,T3,T4,T5,T6> | 
WithStep.select(Field<T1> field1,
      Field<T2> field2,
      Field<T3> field3,
      Field<T4> field4,
      Field<T5> field5,
      Field<T6> field6)
Create a new DSL select statement. 
 | 
<T1,T2,T3,T4,T5,T6> | 
DSLContext.select(Field<T1> field1,
      Field<T2> field2,
      Field<T3> field3,
      Field<T4> field4,
      Field<T5> field5,
      Field<T6> field6)
Create a new DSL select statement. 
 | 
<T1,T2,T3,T4,T5,T6> | 
WithStep.selectDistinct(Field<T1> field1,
              Field<T2> field2,
              Field<T3> field3,
              Field<T4> field4,
              Field<T5> field5,
              Field<T6> field6)
Create a new DSL select statement. 
 | 
<T1,T2,T3,T4,T5,T6> | 
DSLContext.selectDistinct(Field<T1> field1,
              Field<T2> field2,
              Field<T3> field3,
              Field<T4> field4,
              Field<T5> field5,
              Field<T6> field6)
Create a new DSL select statement. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
Condition | 
BetweenAndStep6.and(Record6<T1,T2,T3,T4,T5,T6> maxValue)
Create a condition to check this field against some bounds 
 | 
BetweenAndStep6<T1,T2,T3,T4,T5,T6> | 
Row6.between(Record6<T1,T2,T3,T4,T5,T6> minValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
Row6.between(Record6<T1,T2,T3,T4,T5,T6> minValue,
       Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
Row6.between(Record6<T1,T2,T3,T4,T5,T6> minValue,
       Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is within a range of two records. 
 | 
BetweenAndStep6<T1,T2,T3,T4,T5,T6> | 
Row6.betweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
Condition | 
Row6.betweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue,
                Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
Condition | 
Row6.betweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue,
                Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is within a symmetric range of two
 records. 
 | 
Condition | 
Row6.compare(Comparator comparator,
       Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record
 using a dynamic comparator. 
 | 
Condition | 
Row6.eq(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for equality. 
 | 
Condition | 
Row6.equal(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for equality. 
 | 
Condition | 
Row6.ge(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.greaterOrEqual(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.greaterThan(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.gt(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.in(Record6<T1,T2,T3,T4,T5,T6>... record)
Compare this row value expression with a set of records for equality. 
 | 
Condition | 
Row6.le(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.lessOrEqual(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.lessThan(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.lt(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order. 
 | 
Condition | 
Row6.ne(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for non-equality. 
 | 
BetweenAndStep6<T1,T2,T3,T4,T5,T6> | 
Row6.notBetween(Record6<T1,T2,T3,T4,T5,T6> minValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
Row6.notBetween(Record6<T1,T2,T3,T4,T5,T6> minValue,
          Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is within a range of two records. 
 | 
Condition | 
Row6.notBetween(Record6<T1,T2,T3,T4,T5,T6> minValue,
          Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is within a range of two records. 
 | 
BetweenAndStep6<T1,T2,T3,T4,T5,T6> | 
Row6.notBetweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
Condition | 
Row6.notBetweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue,
                   Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
Condition | 
Row6.notBetweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue,
                   Record6<T1,T2,T3,T4,T5,T6> maxValue)
Check if this row value expression is not within a symmetric range of two
 records. 
 | 
Condition | 
Row6.notEqual(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for non-equality 
 | 
Condition | 
Row6.notIn(Record6<T1,T2,T3,T4,T5,T6>... record)
Compare this row value expression with a set of records for non-equality. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
<T1,T2,T3,T4,T5,T6> | 
UpdateQuery.addValues(Row6<T1,T2,T3,T4,T5,T6> row,
         Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Specify a multi-column set clause for the  
UPDATE statement. | 
Condition | 
Row6.compare(Comparator comparator,
       QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect
 using a dynamic comparator. 
 | 
Condition | 
Row6.compare(Comparator comparator,
       Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect
 using a dynamic comparator. 
 | 
Condition | 
Row6.eq(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
Row6.eq(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
Row6.equal(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
Row6.equal(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
Row6.ge(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.ge(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.greaterOrEqual(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.greaterOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.greaterThan(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.greaterThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.gt(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.gt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.in(Result<? extends Record6<T1,T2,T3,T4,T5,T6>> result)
Compare this row value expression with a set of records for
 equality. 
 | 
Condition | 
Row6.in(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality. 
 | 
Condition | 
Row6.le(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.le(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.lessOrEqual(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.lessOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.lessThan(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.lessThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.lt(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.lt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order. 
 | 
Condition | 
Row6.ne(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
Row6.ne(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
Row6.notEqual(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
Row6.notEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Condition | 
Row6.notIn(Result<? extends Record6<T1,T2,T3,T4,T5,T6>> result)
Compare this row value expression with a set of records for
 equality. 
 | 
Condition | 
Row6.notIn(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality. 
 | 
Merge<R> | 
MergeValuesStep6.select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Use a  
SELECT statement as the source of values for the
 MERGE statement
 
 This variant of the MERGE .. | 
Insert<R> | 
InsertValuesStep6.select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Use a  
SELECT statement as the source of values for the
 INSERT statement
 
 This variant of the INSERT .. | 
<T1,T2,T3,T4,T5,T6> | 
UpdateSetFirstStep.set(Row6<T1,T2,T3,T4,T5,T6> row,
   Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Specify a multi-column set clause for the  
UPDATE statement. | 
| Modifier and Type | Method and Description | 
|---|---|
<T1,T2,T3,T4,T5,T6> | 
DefaultDSLContext.newRecord(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         Field<T5> field5,
         Field<T6> field6)  | 
| Modifier and Type | Method and Description | 
|---|---|
<T1,T2,T3,T4,T5,T6> | 
DefaultDSLContext.newResult(Field<T1> field1,
         Field<T2> field2,
         Field<T3> field3,
         Field<T4> field4,
         Field<T5> field5,
         Field<T6> field6)  | 
static <T1,T2,T3,T4,T5,T6> | 
DSL.select(Field<T1> field1,
      Field<T2> field2,
      Field<T3> field3,
      Field<T4> field4,
      Field<T5> field5,
      Field<T6> field6)
Create a new DSL subselect statement. 
 | 
<T1,T2,T3,T4,T5,T6> | 
DefaultDSLContext.select(Field<T1> field1,
      Field<T2> field2,
      Field<T3> field3,
      Field<T4> field4,
      Field<T5> field5,
      Field<T6> field6)  | 
static <T1,T2,T3,T4,T5,T6> | 
DSL.selectDistinct(Field<T1> field1,
              Field<T2> field2,
              Field<T3> field3,
              Field<T4> field4,
              Field<T5> field5,
              Field<T6> field6)
Create a new DSL subselect statement. 
 | 
<T1,T2,T3,T4,T5,T6> | 
DefaultDSLContext.selectDistinct(Field<T1> field1,
              Field<T2> field2,
              Field<T3> field3,
              Field<T4> field4,
              Field<T5> field5,
              Field<T6> field6)  | 
static <T1,T2,T3,T4,T5,T6> | 
DSL.values(Row6<T1,T2,T3,T4,T5,T6>... rows)
Create a  
VALUES() expression of degree 6. | 
Copyright © 2015. All Rights Reserved.