Select

ldbc.statement.Select

case class Select[A, B](table: A, columns: Column[B], statement: String, params: List[Dynamic]) extends Query[A, B], QueryProvider[A, B]

A model for constructing SELECT statements in MySQL.

Type parameters

columns: Union-type column list
params: A list of Traits that generate values from Parameter, allowing PreparedStatement to be set to a value by index only.
statement: SQL statement string
table: Trait for generating SQL table information.

Source: Select.scala
Graph
Supertypes: trait Serializable

trait Product

trait Equals

trait QueryProvider[A, B]

trait Query[A, B]

trait SQL

class Object

trait Matchable

class Any
Show all

A method for setting the GROUP BY condition in a SELECT statement.

 TableQuery[City]
   .select(_.name)
   .groupBy(_.name)

A method for setting the WHERE condition in a SELECT statement.

 TableQuery[City]
   .select(_.name)
   .where(_.name === "Tokyo")

A method for setting the LIMIT condition in a SELECT statement.

 TableQuery[City]
   .select(_.population)
   .limit(10)

A method for setting the ORDER BY condition in a statement.

TableQuery[City]
  .select(_.population)
  .orderBy(_.population.desc)

In this article

Generated with