PHP Class SqlParser\Statements\UpdateStatement

UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] or UPDATE [LOW_PRIORITY] [IGNORE] table_references SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... [WHERE where_condition]

Author: Dan Ungureanu ([email protected])

Inheritance: extends SqlParser\Statement

Mostra file Open project: phpmyadmin/sql-parser

Public Properties

Property	Type	Description
$CLAUSES	array	The clauses of this statement, in order.
$OPTIONS	array	Options for UPDATE statements and their slot ID.
$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.
$set	SqlParser\Components\SetOperation[]	The updated values.
$tables	SqlParser\Components\Expression[]	Tables used as sources for this statement.
$where	SqlParser\Components\Condition[]	Conditions used for filtering each row of the result set.

Property Details

$CLAUSES public_oe static_oe property

The clauses of this statement, in order.

$OPTIONS public_oe static_oe property

Options for UPDATE statements and their slot ID.

public static array $OPTIONS
return	array

$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[]

$set public_oe property

The updated values.

public SetOperation[],SqlParser\Components $set
return	SqlParser\Components\SetOperation[]

$tables public_oe property

Tables used as sources for this statement.

public Expression[],SqlParser\Components $tables
return	SqlParser\Components\Expression[]

$where public_oe property

Conditions used for filtering each row of the result set.

public Condition[],SqlParser\Components $where
return	SqlParser\Components\Condition[]