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\TableSelectTable 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