PHP Класс SqlParser\Statements\SelectStatement

SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [MAX_STATEMENT_TIME = N] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr ...] [FROM table_references [PARTITION partition_list] [WHERE where_condition] [GROUP BY {col_name | expr | position} [ASC | DESC], ... [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [PROCEDURE procedure_name(argument_list)] [INTO OUTFILE 'file_name' [CHARACTER SET charset_name] export_options | INTO DUMPFILE 'file_name' | INTO var_name [, var_name]] [FOR UPDATE | LOCK IN SHARE MODE]]
Автор: Dan Ungureanu ([email protected])
Наследование: extends SqlParser\Statement
Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство Тип Описание
$CLAUSES array The clauses of this statement, in order.
$END_OPTIONS
$OPTIONS array Options for SELECT statements and their slot ID.
$end_options OptionsArray The end options of this query.
$expr SqlParser\Components\Expression[] Expressions that are being selected by this statement.
$from SqlParser\Components\Expression[] Tables used as sources for this statement.
$group SqlParser\Components\OrderKeyword[] Conditions used for grouping the result set.
$having SqlParser\Components\Condition[] Conditions used for filtering the result set.
$into SqlParser\Components\IntoKeyword Destination of this result set.
$join SqlParser\Components\JoinKeyword[] Joins.
$limit SqlParser\Components\Limit Conditions used for limiting the size of the result set.
$order SqlParser\Components\OrderKeyword[] Specifies the order of the rows in the result set.
$partition SqlParser\Components\ArrayObj Partitions used as source for this statement.
$procedure SqlParser\Components\FunctionCall Procedure that should process the data in the result set.
$union SelectStatement[] Unions.
$where SqlParser\Components\Condition[] Conditions used for filtering each row of the result set.

Открытые методы

Метод Описание
getClauses ( ) : array Gets the clauses of this statement.

Описание методов

getClauses() публичный Метод

Gets the clauses of this statement.
public getClauses ( ) : array
Результат array

Описание свойств

$CLAUSES публичное статическое свойство

The clauses of this statement, in order.
См. также: Statement::$CLAUSES
public static array $CLAUSES
Результат array

$END_OPTIONS публичное статическое свойство

public static $END_OPTIONS

$OPTIONS публичное статическое свойство

Options for SELECT statements and their slot ID.
public static array $OPTIONS
Результат array

$end_options публичное свойство

The end options of this query.
См. также: static::$END_OPTIONS
public OptionsArray $end_options
Результат OptionsArray

$expr публичное свойство

Expressions that are being selected by this statement.
public Expression[],SqlParser\Components $expr
Результат SqlParser\Components\Expression[]

$from публичное свойство

Tables used as sources for this statement.
public Expression[],SqlParser\Components $from
Результат SqlParser\Components\Expression[]

$group публичное свойство

Conditions used for grouping the result set.
public OrderKeyword[],SqlParser\Components $group
Результат SqlParser\Components\OrderKeyword[]

$having публичное свойство

Conditions used for filtering the result set.
public Condition[],SqlParser\Components $having
Результат SqlParser\Components\Condition[]

$into публичное свойство

Destination of this result set.
public IntoKeyword,SqlParser\Components $into
Результат SqlParser\Components\IntoKeyword

$join публичное свойство

Joins.
public JoinKeyword[],SqlParser\Components $join
Результат SqlParser\Components\JoinKeyword[]

$limit публичное свойство

Conditions used for limiting the size of the result set.
public Limit,SqlParser\Components $limit
Результат SqlParser\Components\Limit

$order публичное свойство

Specifies the order of the rows in the result set.
public OrderKeyword[],SqlParser\Components $order
Результат SqlParser\Components\OrderKeyword[]

$partition публичное свойство

Partitions used as source for this statement.
public ArrayObj,SqlParser\Components $partition
Результат SqlParser\Components\ArrayObj

$procedure публичное свойство

Procedure that should process the data in the result set.
public FunctionCall,SqlParser\Components $procedure
Результат SqlParser\Components\FunctionCall

$union публичное свойство

Unions.
public SelectStatement[],SqlParser\Statements $union
Результат SelectStatement[]

$where публичное свойство

Conditions used for filtering each row of the result set.
public Condition[],SqlParser\Components $where
Результат SqlParser\Components\Condition[]