Class Core_QueryBuilder_Select
Query builder. SELECT Database Abstraction Layer (DBAL)
http://dev.mysql.com/doc/refman/5.7/en/select.html
Subqueries http://dev.mysql.com/doc/refman/5.7/en/subqueries.html
The Subquery as Scalar Operand http://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
// SELECT (SELECT MAX(`column2`) FROM `t2`) FROM `t1` $oCore_QueryBuilder_Select2 = Core_QueryBuilder::select('MAX(column2)')->from('t2'); $oCore_QueryBuilder_Select = Core_QueryBuilder::select($oCore_QueryBuilder_Select2)->from('t1');
Comparisons Using Subqueries http://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
// SELECT * FROM `t1` WHERE `column1` = (SELECT MAX(`column2`) FROM `t2`) $oCore_QueryBuilder_Select2 = Core_QueryBuilder::select('MAX(column2)')->from('t2'); $oCore_QueryBuilder_Select = Core_QueryBuilder::select()->from('t1') ->where('column1', '=', $oCore_QueryBuilder_Select2);
- Core_QueryBuilder_Statement
- Core_QueryBuilder_Selection
- Core_QueryBuilder_Select
Direct known subclasses
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
See:
Core_QueryBuilder_Selection
Located at core/querybuilder/select.php
Methods summary
public
|
#
__construct( array $args = array() )
Constructor. $oCore_QueryBuilder_Select = Core_QueryBuilder::select('id', array('tableName.name', 'aliasName')); |
public
|
|
public
|
|
public
array
|
|
public
|
|
public
|
|
public
boolean
|
|
public
|
|
public
boolean
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
array
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
|
public
|
#
orHaving( string $column, string $expression, string $value )
Add OR and HAVING, e.g. HAVING ... OR $column $expression $value |
public
|
#
havingRaw( string $expr )
Add raw expression into HAVING. ATTENTION! Danger, you should escape the query yourself! |
public
|
|
public
|
|
public
|
|
public
array
|
|
public
|
|
public
|
#
union(
UNION is used to combine the result from multiple SELECT statements into a single result set. |
public
|
#
unionAll(
UNION ALL is used to combine the result from multiple SELECT statements into a single result set. |
public
|
#
unionOrderBy( string $column, string $direction = 'ASC', boolean $binary = FALSE )
ORDER BY for UNION |
public
|
|
public
selfion
|
|
public
|
#
offsetPostgreSQLSyntax( $compatible )
Offset compatibility with PostgreSQL, default TRUE $param boolean $compatible |
public
string
|
|
public
boolean
|
#
chunk( integer $count, callable $callback, boolean $bCache = TRUE )
Retrieve a small chunk and feeds each one into $callback for processing. It stops looping when $callback returns FALSE |
public
|
Methods inherited from Core_QueryBuilder_Selection
_buildExpression()
,
_buildIndexHint()
,
_buildJoin()
,
_buildOrderBy()
,
_buildWhere()
,
_join()
,
_quoteTables()
,
asAssoc()
,
asObject()
,
clearIndexHints()
,
clearJoin()
,
clearOrderBy()
,
clearWhere()
,
close()
,
crossJoin()
,
deleteFirstWhere()
,
deleteLastWhere()
,
firstJoin()
,
firstLeftJoin()
,
getJoin()
,
getOrderBy()
,
getWhere()
,
indexHint()
,
join()
,
leftJoin()
,
limit()
,
naturalJoin()
,
offset()
,
open()
,
orWhere()
,
orWhereBetween()
,
orWhereColumn()
,
orWhereIn()
,
orWhereIsNotNull()
,
orWhereIsNull()
,
orWhereNotBetween()
,
orWhereNotIn()
,
order()
,
orderBy()
,
orderByRaw()
,
partition()
,
quoteTable()
,
rightJoin()
,
rightJoinFirst()
,
setAnd()
,
setDefaultOperator()
,
setOperator()
,
setOr()
,
where()
,
whereBetween()
,
whereColumn()
,
whereIn()
,
whereIsNotNull()
,
whereIsNull()
,
whereNotBetween()
,
whereNotIn()
,
whereRaw()
Methods inherited from Core_QueryBuilder_Statement
__call()
,
__set()
,
_isObjectSelect()
,
_quoteColumns()
,
_quoteValues()
,
clearLimit()
,
clearOffset()
,
execute()
,
setDataBase()
,
unbuffered()
Properties summary
protected
boolean
|
$_distinct
DISTINCT |
#
FALSE
|
protected
boolean
|
$_highPriority
HIGH_PRIORITY |
#
FALSE
|
protected
boolean
|
$_straightJoin
STRAIGHT_JOIN |
#
FALSE
|
protected
boolean
|
$_sqlCalcFoundRows
SQL_CALC_FOUND_ROWS |
#
FALSE
|
protected
array
|
$_select
SELECT |
#
array()
|
protected
array
|
$_from
FROM |
#
array()
|
protected
array
|
$_groupBy
GROUP BY |
#
array()
|
protected
array
|
$_having
HAVING |
#
array()
|
protected
array
|
$_union
Array of Core_QueryBuilder_Select's |
#
array()
|
protected
array
|
$_unionOrderBy
UNION ORDER BY |
#
array()
|
protected
mixed
|
$_unionLimit
UNION LIMIT |
#
NULL
|
protected
mixed
|
$_unionOffset
UNION OFFSET |
#
NULL
|
protected
integer
|
$_queryType
DataBase Query Type 0 - SELECT |
#
0
|
protected
boolean
|
$_offsetPostgreSQLSyntax
Offset compatibility with PostgreSQL, default TRUE |
#
TRUE
|
Properties inherited from Core_QueryBuilder_Selection
$_defaultOperator
,
$_indexHints
,
$_join
,
$_limit
,
$_offset
,
$_operator
,
$_orderBy
,
$_partition
,
$_where