• 홈
• SqlParser
• Statements
• SelectStatement

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]] 파일 보기 프로젝트 열기: phpmyadmin/sql-parser 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
$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.

메소드 상세

프로퍼티 상세