PHP Class 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]]
Author: Dan Ungureanu ([email protected])
Inheritance: extends SqlParser\Statement
Exibir arquivo Open project: phpmyadmin/sql-parser Class Usage Examples

Public Properties

Property Type Description
$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.

Public Methods

Method Description
getClauses ( ) : array Gets the clauses of this statement.

Method Details

getClauses() public method

Gets the clauses of this statement.
public getClauses ( ) : array
return array

Property Details

$CLAUSES public_oe static_oe property

The clauses of this statement, in order.
See also: Statement::$CLAUSES
public static array $CLAUSES
return array

$END_OPTIONS public_oe static_oe property

public static $END_OPTIONS

$OPTIONS public_oe static_oe property

Options for SELECT statements and their slot ID.
public static array $OPTIONS
return array

$end_options public_oe property

The end options of this query.
See also: static::$END_OPTIONS
public OptionsArray $end_options
return OptionsArray

$expr public_oe property

Expressions that are being selected by this statement.
public Expression[],SqlParser\Components $expr
return SqlParser\Components\Expression[]

$from public_oe property

Tables used as sources for this statement.
public Expression[],SqlParser\Components $from
return SqlParser\Components\Expression[]

$group public_oe property

Conditions used for grouping the result set.
public OrderKeyword[],SqlParser\Components $group
return SqlParser\Components\OrderKeyword[]

$having public_oe property

Conditions used for filtering the result set.
public Condition[],SqlParser\Components $having
return SqlParser\Components\Condition[]

$into public_oe property

Destination of this result set.
public IntoKeyword,SqlParser\Components $into
return SqlParser\Components\IntoKeyword

$join public_oe property

Joins.
public JoinKeyword[],SqlParser\Components $join
return SqlParser\Components\JoinKeyword[]

$limit public_oe property

Conditions used for limiting the size of the result set.
public Limit,SqlParser\Components $limit
return SqlParser\Components\Limit

$order public_oe property

Specifies the order of the rows in the result set.
public OrderKeyword[],SqlParser\Components $order
return SqlParser\Components\OrderKeyword[]

$partition public_oe property

Partitions used as source for this statement.
public ArrayObj,SqlParser\Components $partition
return SqlParser\Components\ArrayObj

$procedure public_oe property

Procedure that should process the data in the result set.
public FunctionCall,SqlParser\Components $procedure
return SqlParser\Components\FunctionCall

$union public_oe property

Unions.
public SelectStatement[],SqlParser\Statements $union
return SelectStatement[]

$where public_oe property

Conditions used for filtering each row of the result set.
public Condition[],SqlParser\Components $where
return SqlParser\Components\Condition[]