TableSelect::bind »

« TableInsert::values

TableSelect class

(PECL mysql-xdevapi >= 8.0.11)

Introduction

A statement for record retrieval operations on a Table.

Class synopsis

classmysql_xdevapi\TableSelectimplementsmysql_xdevapi\Executable {

publicbind(array$placeholder_values): mysql_xdevapi\TableSelect

publicexecute(): mysql_xdevapi\RowResult

publicgroupBy(mixed$sort_expr): mysql_xdevapi\TableSelect

publichaving(string$sort_expr): mysql_xdevapi\TableSelect

publiclimit(int$rows): mysql_xdevapi\TableSelect

publiclockExclusive(int$lock_waiting_option = ?): mysql_xdevapi\TableSelect

publiclockShared(int$lock_waiting_option = ?): mysql_xdevapi\TableSelect

publicoffset(int$position): mysql_xdevapi\TableSelect

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

publicwhere(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