Pure
Attributes
- Source
- Column.scala
- Graph
-
- Supertypes
Members list
Value members
Concrete methods
Column alias name
Functions for setting aliases on columns
Function to get a value of type T from a ResultSet
Function to get a value of type T from a ResultSet
Attributes
- Definition Classes
- Source
- Column.scala
Used in Update statement Column = VALUES(Column), Column = VALUES(Column)
used in the Duplicate Key Update statement
Used in Update statement Column = VALUES(Column), Column = VALUES(Column)
used in the Duplicate Key Update statement
Attributes
- Definition Classes
- Source
- Column.scala
Function to set a value of type T to a PreparedStatement
Function to set a value of type T to a PreparedStatement
Attributes
- Definition Classes
- Source
- Column.scala
Used in Insert statement (Column, Column) VALUES (?,?)
used in the Insert statement
Used in Insert statement (Column, Column) VALUES (?,?)
used in the Insert statement
Attributes
- Definition Classes
- Source
- Column.scala
Column Field Name
Used in Update statement Column = ?, Column = ?
used in the Update statement
Used in Update statement Column = ?, Column = ?
used in the Update statement
Attributes
- Definition Classes
- Source
- Column.scala
Indicator of how many columns are specified
Inherited methods
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.
A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id !== 1L)
// SELECT name, age FROM user WHERE id != ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are not equal in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set the WHERE condition for modulo operations in a SELECT statement.
A function to set the WHERE condition for modulo operations in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id %(1L, 2L))
// SELECT name, age FROM user WHERE id % ? = ?
Value parameters
- cond
-
Condition to check
- result
-
Result to compare
Attributes
- Returns
-
A query to check the modulo operation in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
A function to multiply columns in a SELECT statement.
A function to multiply columns in a SELECT statement.
TableQuery[User].select(user => user.name * user.age)
// SELECT name * age FROM user
Value parameters
- other
-
Column to multiply
Attributes
- Returns
-
A query to multiply columns in a SELECT statement
- Inherited from:
- Column
- Source
- Column.scala
A function to combine columns in a SELECT statement.
A function to combine columns in a SELECT statement.
TableQuery[User].select(user => user.name ++ user.age)
// SELECT name + age FROM user
Value parameters
- other
-
Column to combine
Attributes
- Returns
-
A query to combine columns in a SELECT statement
- Inherited from:
- Column
- Source
- Column.scala
A function to subtract columns in a SELECT statement.
A function to subtract columns in a SELECT statement.
TableQuery[User].select(user => user.name -- user.age)
// SELECT name - age FROM user
Value parameters
- other
-
Column to subtract
Attributes
- Returns
-
A query to subtract columns in a SELECT statement
- Inherited from:
- Column
- Source
- Column.scala
A function to divide columns in a SELECT statement.
A function to divide columns in a SELECT statement.
TableQuery[User].select(user => user.name / user.age)
// SELECT name / age FROM user
Value parameters
- other
-
Column to divide
Attributes
- Returns
-
A query to divide columns in a SELECT statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are less than in a SELECT statement.
A function that sets a WHERE condition to check whether the values are less than in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id < 1L)
// SELECT name, age FROM user WHERE id < ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are less than in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set a WHERE condition to check whether the values are shifted to the left in a SELECT statement.
A function to set a WHERE condition to check whether the values are shifted to the left in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id << 1L)
// SELECT name, age FROM user WHERE id << ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are shifted to the left in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are less than or equal to in a SELECT statement.
A function that sets a WHERE condition to check whether the values are less than or equal to in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id <= 1L)
// SELECT name, age FROM user WHERE id <= ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are less than or equal to in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id <=> 1L)
// SELECT name, age FROM user WHERE id <=> ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are equal in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.
A function that sets a WHERE condition to check whether the values are not equal in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id <> 1L)
// SELECT name, age FROM user WHERE id <> ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are not equal in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to perform a comparison with the column of interest using a subquery.
A function to perform a comparison with the column of interest using a subquery.
val sub: SQL = ???
TableQuery[User].select(user => user.name *: user.age).where(_.id === sub)
// SELECT name, age FROM user WHERE id = (SELECT ...)
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to compare with the column of interest using a subquery
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values match in a SELECT statement.
A function that sets a WHERE condition to check whether the values match in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id === 1L)
// SELECT name, age FROM user WHERE id = ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values match in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are greater than in a SELECT statement.
A function that sets a WHERE condition to check whether the values are greater than in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id > 1L)
// SELECT name, age FROM user WHERE id > ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are greater than in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are greater than or equal to in a SELECT statement.
A function that sets a WHERE condition to check whether the values are greater than or equal to in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id >= 1L)
// SELECT name, age FROM user WHERE id >= ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are greater than or equal to in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set a WHERE condition to check whether the values are shifted to the right in a SELECT statement.
A function to set a WHERE condition to check whether the values are shifted to the right in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id >> 1L)
// SELECT name, age FROM user WHERE id >> ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are shifted to the right in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether a value is included in a specified range in a SELECT statement.
A function that sets a WHERE condition to check whether a value is included in a specified range in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.updateAt BETWEEN (LocalDateTime.now(), LocalDateTime.now()))
// SELECT name, age FROM user WHERE update_at BETWEEN ? AND ?
Value parameters
- end
-
End value
- start
-
Start value
Attributes
- Returns
-
A query to check whether the value is included in a specified range in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set a WHERE condition to check whether the values are added in a SELECT statement.
A function to set a WHERE condition to check whether the values are added in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id DIV(1L, 2L))
// SELECT name, age FROM user WHERE id DIV ? = ?
Value parameters
- cond
-
Condition to check
- result
-
Result to compare
Attributes
- Returns
-
A query to check whether the values are added in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id IN (1L, 2L, 3L))
// SELECT name, age FROM user WHERE id IN (?, ?, ?)
Value parameters
- head
-
Value to compare
- tail
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are equal in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id IN NonEmptyList.of(1L, 2L, 3L))
// SELECT name, age FROM user WHERE id IN (?, ?, ?)
Value parameters
- values
-
Value to compare
Attributes
- Returns
-
A query to check whether the values are equal in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
A function that sets a WHERE condition to check whether the values are equal in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id IS "NULL")
// SELECT name, age FROM user WHERE id IS NULL
Type parameters
- B
-
Type of value to compare
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
Query to check whether values are equal in a Where statement.
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.
A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.name LIKE "Tak%")
// SELECT name, age FROM user WHERE name LIKE ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check a value with an ambiguous search in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.
A function to set a WHERE condition to check a value with an ambiguous search in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.name LIKE "Tak%" ESCAPE "!")
// SELECT name, age FROM user WHERE name LIKE ? ESCAPE ?
Value parameters
- escape
-
Value to escape
- like
-
Value to compare
Attributes
- Returns
-
A query to check a value with an ambiguous search in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set the WHERE condition for modulo operations in a SELECT statement.
A function to set the WHERE condition for modulo operations in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id MOD(1L, 2L))
// SELECT name, age FROM user WHERE id MOD ? = ?
Value parameters
- cond
-
Condition to check
- result
-
Result to compare
Attributes
- Returns
-
A query to check the modulo operation in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set a WHERE condition to check values in a regular expression in a SELECT statement.
A function to set a WHERE condition to check values in a regular expression in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.name REGEXP "Tak.*")
// SELECT name, age FROM user WHERE name REGEXP ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check values in a regular expression in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set the WHERE condition for bitwise XOR operations in a SELECT statement.
A function to set the WHERE condition for bitwise XOR operations in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id ^ 1L)
// SELECT name, age FROM user WHERE id ^ ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check the bitwise XOR operation in a Where statement
- Inherited from:
- Column
- Source
- Column.scala
List of join query methods
List of sub query methods
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Product
Attributes
- Inherited from:
- Product
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Used in select statement Column, Column
used in the Insert statement
Used in select statement Column, Column
used in the Insert statement
Attributes
- Inherited from:
- Column
- Source
- Column.scala
Returns a string representation of the object.
Returns a string representation of the object.
The default representation is platform dependent.
Attributes
- Returns
-
a string representation of the object.
- Definition Classes
-
Column -> Any
- Inherited from:
- Column
- Source
- Column.scala
Attributes
- Inherited from:
- Column
- Source
- Column.scala
A function to set the WHERE condition for bitwise NOT operations in a SELECT statement.
A function to set the WHERE condition for bitwise NOT operations in a SELECT statement.
TableQuery[User].select(user => user.name *: user.age).where(_.id ~ 1L)
// SELECT name, age FROM user WHERE id ~ ?
Value parameters
- value
-
Value to compare
Attributes
- Returns
-
A query to check the bitwise NOT operation in a Where statement
- Inherited from:
- Column
- Source
- Column.scala