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

UpdateStatement

class UpdateStatement extends Statement

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.
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 $parser = null, TokensList $list = null)

Constructor.

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 87
__construct(Parser $parser = null, TokensList $list = null)

Constructor.

Parameters

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

in Statement at line 99
string build()

Builds the string representation of this statement.

Return Value

string

in Statement at line 194
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

in Statement at line 414
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 425
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 434
array getClauses()

Gets the clauses of this statement.

Return Value

array

in Statement at line 446
string __toString()

Builds the string representation of this statement.

Return Value

string

See also

in Statement at line 461
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