Class Statement
Select-Statement
Abbilden einer SELECT-Abfrage an eine relationale Datenbank mit Unterstützung von SQL2011.
$statement = new SelectStatement('SELECT a FROM b WHERE c');
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] expression [ <![AS]> name ] [,...] [ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ] [ FROM {table | (select query)} [ alias ] [,...] ] [ {{LEFT | RIGHT} [OUTER] | NATURAL |[FULL] OUTER} JOIN table alias {ON condition | USING(col1,col2,...)} ] [ WHERE {condition | EXISTS (correlated subquery)} ] [ GROUP BY column [,...] ] [ HAVING condition [,...] ] [ { UNION [ ALL ] | INTERSECT | EXCEPT | MINUS } select ] [ ORDER BY {column | int} [ ASC | DESC | USING operator ] [,...] ] [ FOR UPDATE [ OF class_name [,...] ] ] LIMIT { count | ALL } [ { OFFSET | ,} start ]
- Alvine\Core\Alvine implements Serializable uses Alvine\Core\SerializableImplementation
- Alvine\Persistence\Relation\Statement
- Alvine\Persistence\Relation\GenericStatement
- Alvine\Persistence\Relation\SQL\Select\Statement
Namespace: Alvine\Persistence\Relation\SQL\Select
Package: Alvine\Persistence\Relation\SQL\Select
Category: Framework
License: Licence
Author: schukai GmbH info@schukai.de
Version: Release: $Revision: 173 $
Since: 20130809
Link: Alvine
Link: SQL-Standard
Link: Statements für verschiedenen Server
Located at persistence/relation/sql/select/Statement.class.php
Package: Alvine\Persistence\Relation\SQL\Select
Category: Framework
License: Licence
Author: schukai GmbH info@schukai.de
Version: Release: $Revision: 173 $
Since: 20130809
Link: Alvine
Link: SQL-Standard
Link: Statements für verschiedenen Server
Located at persistence/relation/sql/select/Statement.class.php
__construct(),
__toString()
|
__call(),
__clone(),
__get(),
__set(),
equals(),
getClass(),
getClone(),
getClosure(),
getHashCode(),
getID(),
getShortID(),
isCallable(),
isInstanceOf(),
propertyExists()
|
serialize(),
unserialize()
|
checkAndAdjustSerialisation(),
serialize(),
unserialize()
|
string |
SELECT
SELECT |
#
'SELECT'
|
string |
FROM
FROM |
#
'FROM'
|
string |
ALIAS
Alias AS |
#
'AS'
|
string |
JOIN
JOIN |
#
'JOIN'
|
string |
ON
ON |
#
'ON'
|
KEYWORD
|
APIVERSION,
IDENTIFICATION,
SERIALVERSION,
VERSION
|
$statement
|
$hash,
$properties
|