class LoadStatement extends Statement (View source)

LOAD statement.

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [PARTITION (partition_name,...)] [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number {LINES | ROWS}] [(col_name_or_user_var,...)] [SET col_name = expr,...]

Properties

static array $OPTIONS

Options for LOAD statements and their slot ID.

static array $CLAUSES

The clauses of this statement, in order.

from  Statement
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
static array $FIELDS_OPTIONS

FIELDS/COLUMNS Options for LOAD DATA...INFILE statements.

static array $LINES_OPTIONS

LINES Options for LOAD DATA...INFILE statements.

Expression $file_name

File name being used to load data.

Expression $table

Table used as destination for this statement.

ArrayObj $partition

Partitions used as source for this statement.

Expression $charset_name

Character set used in this statement.

OptionsArray $fields_options

Options for FIELDS/COLUMNS keyword.

string $fields_keyword

Whether to use FIELDS or COLUMNS while building.

OptionsArray $lines_options

Options for OPTIONS keyword.

Expression[] $col_name_or_user_var

Column names or user variables.

SetOperation[] $set

SET clause's updated values(optional).

Expression $ignore_number

Ignore 'number' LINES/ROWS.

string $replace_ignore

REPLACE/IGNORE Keyword.

string $lines_rows

LINES/ROWS Keyword.

Methods

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

No description

string
build()

No description

parse(Parser $parser, TokensList $list)

No description

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.

void
parseFileOptions(Parser $parser, TokensList $list, string $keyword = 'FIELDS')

No description

int
parseKeywordsAccordingToState(Parser $parser, TokensList $list, int $state)

No description

Details

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

No description

Parameters

Parser|null $parser

the instance that requests parsing

TokensList|null $list

the list of tokens to be parsed

string build()

No description

Return Value

string

parse(Parser $parser, TokensList $list)

No description

Parameters

Parser $parser

the instance that requests parsing

TokensList $list

the list of tokens to be parsed

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

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

array getClauses()

Gets the clauses of this statement.

Return Value

array

string __toString()

Builds the string representation of this statement.

Return Value

string

See also

static::build

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

void parseFileOptions(Parser $parser, TokensList $list, string $keyword = 'FIELDS')

No description

Parameters

Parser $parser

The parser

TokensList $list

A token list

string $keyword

The keyword

Return Value

void

int parseKeywordsAccordingToState(Parser $parser, TokensList $list, int $state)

No description

Parameters

Parser $parser
TokensList $list
int $state

Return Value

int