1. class
  2. PhpMyAdmin
  3. \
  4. SqlParser
  5. \
  6. Statements
  7. \
  8. UpdateStatement

UpdateStatement

class UpdateStatement extends Statement (View source)

UPDATE statement.

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]

Properties

static array $OPTIONS Options for UPDATE statements and their slot ID.
static array $CLAUSES The clauses of this statement, in order.
static array $END_OPTIONS from  Statement
OptionsArray $options The options of this query. from  Statement
int $first The index of the first token used in this statement. from  Statement
int $last The index of the last token used in this statement. from  Statement
Expression[] $tables Tables used as sources for this statement.
SetOperation[] $set The updated values.
Condition[] $where Conditions used for filtering each row of the result set.
OrderKeyword[] $order Specifies the order of the rows in the result set.
Limit $limit Conditions used for limiting the size of the result set.

Methods

__construct(Parser|null $parser = null, TokensList|null $list = null)

No description

from  Statement
string
build()

Builds the string representation of this statement.

from  Statement
parse(Parser $parser, TokensList $list)

Parses the statements defined by the tokens list.

from  Statement
before(Parser $parser, TokensList $list, Token $token)

Function called before the token is processed.

from  Statement
after(Parser $parser, TokensList $list, Token $token)

Function called after the token was processed.

from  Statement
array
getClauses()

Gets the clauses of this statement.

from  Statement
string
__toString()

Builds the string representation of this statement.

from  Statement
bool
validateClauseOrder(Parser $parser, TokensList $list)

Validates the order of the clauses in parsed statement Ideally this should be called after successfully completing the parsing of each statement.

from  Statement

Details

in Statement at line 92
__construct(Parser|null $parser = null, TokensList|null $list = null)

Parameters

Parser|null $parser the instance that requests parsing
TokensList|null $list the list of tokens to be parsed

in Statement at line 104
string build()

Builds the string representation of this statement.

Return Value

string

in Statement at line 202
parse(Parser $parser, TokensList $list)

Parses the statements defined by the tokens list.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed

Exceptions

ParserException

in Statement at line 439
before(Parser $parser, TokensList $list, Token $token)

Function called before the token is processed.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed
Token $token the token that is being parsed

in Statement at line 450
after(Parser $parser, TokensList $list, Token $token)

Function called after the token was processed.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed
Token $token the token that is being parsed

in Statement at line 459
array getClauses()

Gets the clauses of this statement.

Return Value

array

in Statement at line 471
string __toString()

Builds the string representation of this statement.

Return Value

string

See also

static::build

in Statement at line 488
bool validateClauseOrder(Parser $parser, TokensList $list)

Validates the order of the clauses in parsed statement Ideally this should be called after successfully completing the parsing of each statement.

Parameters

Parser $parser the instance that requests parsing
TokensList $list the list of tokens to be parsed

Return Value

bool

Exceptions

ParserException