Method for setting the primary key to the column.
Method for setting the primary key to the column.
Attributes
- Inherited from:
- DataTypeColumn
- Source
- DataTypeColumn.scala
Method for setting Character Set to DataType in SQL.
Method for setting Character Set to DataType in SQL.
Character Set
Method for setting Collation to DataType in SQL.
Method for setting Collation to DataType in SQL.
Collation
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 to compare
A query to check whether the values are not equal in a Where statement
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 % ? = ?
Condition to check
Result to compare
A query to check the modulo operation in a Where statement
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
Column to multiply
A query to multiply columns in a SELECT statement
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
Column to combine
A query to combine columns in a SELECT statement
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
Column to subtract
A query to subtract columns in a SELECT statement
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
Column to divide
A query to divide columns in a SELECT statement
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 to compare
A query to check whether the values are less than in a Where statement
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 to compare
A query to check whether the values are shifted to the left in a Where statement
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 to compare
A query to check whether the values are less than or equal to in a Where statement
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 to compare
A query to check whether the values are equal in a Where statement
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 to compare
A query to check whether the values are not equal in a Where statement
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 to compare
A query to compare with the column of interest using a subquery
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 to compare
A query to check whether the values match in a Where statement
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 to compare
A query to check whether the values are greater than in a Where statement
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 to compare
A query to check whether the values are greater than or equal to in a Where statement
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 to compare
A query to check whether the values are shifted to the right in a Where statement
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 ?
End value
Start value
A query to check whether the value is included in a specified range in a Where statement
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 ? = ?
Condition to check
Result to compare
A query to check whether the values are added in a Where statement
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 to compare
Value to compare
A query to check whether the values are equal in a Where statement
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 to compare
A query to check whether the values are equal in a Where statement
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 of value to compare
Value to compare
Query to check whether values are equal in a Where statement.
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 to compare
A query to check a value with an ambiguous search in a Where statement
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 to escape
Value to compare
A query to check a value with an ambiguous search in a Where statement
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 ? = ?
Condition to check
Result to compare
A query to check the modulo operation in a Where statement
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 to compare
A query to check values in a regular expression in a Where statement
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 to compare
A query to check the bitwise XOR operation in a Where statement
List of join query methods
List of sub query methods
Method for setting the comment to the column.
Method for setting the comment to the column.
Used in Insert statement (Column, Column) VALUES (?,?)
used in the Insert statement
Used in Insert statement (Column, Column) VALUES (?,?)
used in the Insert statement
Method for setting the primary key to the column.
Method for setting the primary key to the column.
Used in select statement Column, Column
used in the Insert statement
Used in select statement Column, Column
used in the Insert statement
Returns a string representation of the object.
Returns a string representation of the object.
The default representation is platform dependent.
a string representation of the object.
Method for setting the unique key to the column.
Method for setting the unique key to the column.
Indicator of how many columns are specified
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 to compare
A query to check the bitwise NOT operation in a Where statement
Column alias name
Functions for setting aliases on columns
List of attributes to be set for the column
List of attributes to be set for the column
Data type to be set for the column
Data type to be set for the column
Function to get a value of type T from a ResultSet
Function to get a value of type T from a ResultSet
Method for setting the default value to the current time.
Method for setting the default value to the current time.
Method for setting the default value to NULL.
Method for setting the default value to NULL.
Default value to be set for the column
Default value to be set for the column
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
Function to set a value of type T to a PreparedStatement
Function to set a value of type T to a PreparedStatement
Value indicating whether DataType is null-allowed or not.
Value indicating whether DataType is null-allowed or not.
true if NULL is allowed, false if NULL is not allowed
Column Field Name
Method for setting the attributes to the column.
Method for setting the attributes to the column.
Used in Update statement Column = ?, Column = ?
used in the Update statement
Used in Update statement Column = ?, Column = ?
used in the Update statement