MySQL Connector/C++ 9.1.0
MySQL connector library for C and C++ applications
Public Member Functions | List of all members
TableSelect Class Reference

An operation which selects rows from a table. More...

Public Member Functions

Operation & where (const string &expr)
 Specify row selection criteria. More...
 
Operation & groupBy (Expr... group_by_spec)
 Specify grouping of items in a query result. More...
 
Operation & having (const string &having_spec)
 Specify filter over grouped results of a query. More...
 

Detailed Description

An operation which selects rows from a table.

The class defines various methods, such as where(), to specify which rows should be returned and in which order.

For each row the operation can return all fields from the row or a set of values defined by projection expressions specified when the operation was created.

Member Function Documentation

◆ where()

Operation & where ( const string expr)
inline

Specify row selection criteria.

The criteria is specified as a Boolean expression string.

◆ groupBy()

Operation & groupBy ( Expr...  group_by_spec)
inlineinherited

Specify grouping of items in a query result.

Arguments are a one or more expressions. Documents/rows for which expressions evaluate to the same value are grouped together.

◆ having()

Operation & having ( const string having_spec)
inlineinherited

Specify filter over grouped results of a query.

The argument is a Boolean expression which can use aggregation functions.


The documentation for this class was generated from the following file: