TableSelect class
(PECL mysql-xdevapi >= 8.0.11)
简介
A statement for record retrieval operations on a Table.
类摘要
mysql_xdevapi\TableSelect
implements mysql_xdevapi\Executable {
/* 方法 */
public
bind (
array
$placeholder_values ) :
mysql_xdevapi\TableSelect
public
execute (
void ) :
mysql_xdevapi\RowResult
public
having (
string
$sort_expr ) :
mysql_xdevapi\TableSelect
public
limit (
integer
$rows ) :
mysql_xdevapi\TableSelect
public
lockExclusive ([
integer
$lock_waiting_option ] ) :
mysql_xdevapi\TableSelect
public
lockShared ([
integer
$lock_waiting_option ] ) :
mysql_xdevapi\TableSelect
public
offset (
integer
$position ) :
mysql_xdevapi\TableSelect
public
where (
string
}
$where_expr ) :
mysql_xdevapi\TableSelect
Table of Contents
- 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
