array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'zh', ), 'this' => array ( 0 => 'class.mysql-xdevapi-tableselect.php', 1 => 'mysql_xdevapi\\TableSelect', 2 => 'TableSelect class', ), 'up' => array ( 0 => 'book.mysql-xdevapi.php', 1 => 'Mysql_xdevapi', ), 'prev' => array ( 0 => 'mysql-xdevapi-tableinsert.values.php', 1 => 'TableInsert::values', ), 'next' => array ( 0 => 'mysql-xdevapi-tableselect.bind.php', 1 => 'TableSelect::bind', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/mysql_xdevapi/mysql-xdevapi.tableselect.xml', ), 'history' => array ( ), 'extra_header_links' => array ( 'rel' => 'alternate', 'href' => '/manual/en/feeds/class.mysql-xdevapi-tableselect.atom', 'type' => 'application/atom+xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

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 bind(array $placeholder_values): mysql_xdevapi\TableSelect

public execute(): mysql_xdevapi\RowResult

public groupBy(mixed $sort_expr): mysql_xdevapi\TableSelect

public having(string $sort_expr): mysql_xdevapi\TableSelect

public limit(int $rows): mysql_xdevapi\TableSelect

public lockExclusive(int $lock_waiting_option = ?): mysql_xdevapi\TableSelect

public lockShared(int $lock_waiting_option = ?): mysql_xdevapi\TableSelect

public offset(int $position): mysql_xdevapi\TableSelect

public orderby(mixed $sort_expr, mixed ...$sort_exprs): mysql_xdevapi\TableSelect

public 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