PHP Class SqlParser\Statements\DeleteStatement

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [PARTITION (partition_name,...)] [WHERE where_condition] [ORDER BY ...] [LIMIT row_count]
Author: Dan Ungureanu ([email protected])
Inheritance: extends SqlParser\Statement
Show file Open project: phpmyadmin/sql-parser

Public Properties

Property Type Description
$CLAUSES array The clauses of this statement, in order.
$OPTIONS array Options for DELETE statements.
$columns SqlParser\Components\Expression[] Columns used in this statement
$from SqlParser\Components\Expression[] Table(s) used as sources for this statement.
$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.
$using SqlParser\Components\Expression[] Tables used as sources for this statement
$where SqlParser\Components\Condition[] Conditions used for filtering each row of the result set.

Public Methods

Method Description
build ( ) : string
parse ( Parser $parser, TokensList $list ) : void

Method Details

build() public method

public build ( ) : string
return string

parse() public method

public parse ( Parser $parser, TokensList $list ) : void
$parser SqlParser\Parser The instance that requests parsing.
$list SqlParser\TokensList The list of tokens to be parsed.
return void

Property Details

$CLAUSES public static property

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

$OPTIONS public static property

Options for DELETE statements.
public static array $OPTIONS
return array

$columns public property

Columns used in this statement
public Expression[],SqlParser\Components $columns
return SqlParser\Components\Expression[]

$from public property

Table(s) used as sources for this statement.
public Expression[],SqlParser\Components $from
return SqlParser\Components\Expression[]

$limit public property

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

$order public property

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

$partition public property

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

$using public property

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

$where public property

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