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
Function called before the token is processed.
Function called after the token was processed.
Validates the order of the clauses in parsed statement Ideally this should be called after successfully completing the parsing of each statement.
Details
__construct(Parser|null $parser = null, TokensList|null $list = null)
string
build()
Builds the string representation of this statement.
parse(Parser $parser, TokensList $list)
Parses the statements defined by the tokens list.
before(Parser $parser, TokensList $list, Token $token)
Function called before the token is processed.
after(Parser $parser, TokensList $list, Token $token)
Function called after the token was processed.
array
getClauses()
Gets the clauses of this statement.
string
__toString()
Builds the string representation of this 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.