PHP Class SqlParser\Statements\InsertStatement

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name,...)] [(col_name,...)] {VALUES | VALUE} ({expr | DEFAULT},...),(...),... [ ON DUPLICATE KEY UPDATE col_name=expr [, col_name=expr] ... ] or INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name,...)] SET col_name={expr | DEFAULT}, ... [ ON DUPLICATE KEY UPDATE col_name=expr [, col_name=expr] ... ] or INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name,...)] [(col_name,...)] SELECT ... [ ON DUPLICATE KEY UPDATE col_name=expr [, col_name=expr] ... ]
Inheritance: extends SqlParser\Statement
Show file Open project: phpmyadmin/sql-parser

Public Properties

Property Type Description
$OPTIONS array Options for INSERT statements.
$into SqlParser\Components\IntoKeyword Tables used as target for this statement.
$onDuplicateSet SqlParser\Components\SetOperation[] If ON DUPLICATE KEY UPDATE clause is present holds the SetOperation
$select SelectStatement If SELECT clause is present holds the SelectStatement
$set SqlParser\Components\SetOperation[] If SET clause is present holds the SetOperation
$values SqlParser\Components\Array2d Values to be inserted.

Public Methods

Method Description
build ( ) : string
parse ( Parser $parser, TokensList $list ) : void

Method Details

build() public method

public build ( ) : string
return string

parse() public method

public parse ( Parser $parser, TokensList $list ) : void
$parser SqlParser\Parser The instance that requests parsing.
$list SqlParser\TokensList The list of tokens to be parsed.
return void

Property Details

$OPTIONS public static property

Options for INSERT statements.
public static array $OPTIONS
return array

$into public property

Tables used as target for this statement.
public IntoKeyword,SqlParser\Components $into
return SqlParser\Components\IntoKeyword

$onDuplicateSet public property

If ON DUPLICATE KEY UPDATE clause is present holds the SetOperation
public SetOperation[],SqlParser\Components $onDuplicateSet
return SqlParser\Components\SetOperation[]

$select public property

If SELECT clause is present holds the SelectStatement
public SelectStatement,SqlParser\Statements $select
return SelectStatement

$set public property

If SET clause is present holds the SetOperation
public SetOperation[],SqlParser\Components $set
return SqlParser\Components\SetOperation[]

$values public property

Values to be inserted.
public Array2d,SqlParser\Components $values
return SqlParser\Components\Array2d