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

CreateStatement

class CreateStatement extends Statement

CREATE statement.

Properties

static array $OPTIONS Options for CREATE statements.
static array $CLAUSES The clauses of this statement, in order. 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
static array $DB_OPTIONS All database options.
static array $TABLE_OPTIONS All table options.
static array $FUNC_OPTIONS All function options.
static array $TRIGGER_OPTIONS All trigger options.
Expression $name The name of the entity that is created.
OptionsArray $entityOptions The options of the entity (table, procedure, function, etc.).
CreateDefinition[]|ArrayObj $fields If CREATE TABLE, a list of columns and keys.
SelectStatement $select If `CREATE TABLE .
Expression $like If `CREATE TABLE .
string $partitionBy Expression used for partitioning.
int $partitionsNum The number of partitions.
string $subpartitionBy Expression used for subpartitioning.
int $subpartitionsNum The number of subpartitions.
PartitionDefinition[] $partitions The partition of the new table.
Expression $table If CREATE TRIGGER the name of the table.
DataType $return The return data type of this routine.
ParameterDefinition[] $parameters The parameters of this routine.
Token[]|string $body The body of this function or procedure. For views, it is the select statement that gets the.

Methods

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

Constructor.

from Statement
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.

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

at line 375
string build()

Builds the string representation of this statement.

Return Value

string

at line 465
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