# TableSelect class

(PECL mysql-xdevapi >= 8.0.11)

## 简介

A statement for record retrieval operations on a Table.

## 类摘要

class mysql_xdevapi\TableSelect implements mysql_xdevapi\Executable {
/* 方法 */
public function bind(array `$placeholder_values`): mysql_xdevapi\TableSelect
public function execute(): mysql_xdevapi\RowResult
public function groupBy(mixed `$sort_expr`): mysql_xdevapi\TableSelect
public function having(string `$sort_expr`): mysql_xdevapi\TableSelect
public function limit(int `$rows`): mysql_xdevapi\TableSelect
public function lockExclusive(int `$lock_waiting_option` = ?): mysql_xdevapi\TableSelect
public function lockShared(int `$lock_waiting_option` = ?): mysql_xdevapi\TableSelect
public function offset(int `$position`): mysql_xdevapi\TableSelect
public function orderby(mixed `$sort_expr`, mixed `...$sort_exprs`): mysql_xdevapi\TableSelect
public function where(string `$where_expr`): mysql_xdevapi\TableSelect
}

## 目录

- TableSelect::bind — Bind select query parameters
- TableSelect::__construct — TableSelect constructor
- TableSelect::execute — Execute select statement
- TableSelect::groupBy — Set select grouping criteria
- TableSelect::having — Set select having condition
- TableSelect::limit — Limit selected rows
- TableSelect::lockExclusive — Execute EXCLUSIVE LOCK
- TableSelect::lockShared — Execute SHARED LOCK
- TableSelect::offset — Set limit offset
- TableSelect::orderby — Set select sort criteria
- TableSelect::where — Set select search condition

`↑` and `↓` to navigate • `Enter` to select • `Esc` to close • `/` to open