PHP Класс 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] ... ]
Наследование: extends SqlParser\Statement
Показать файл Открыть проект

Открытые свойства

Свойство Тип Описание
$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.

Открытые методы

Метод Описание
build ( ) : string
parse ( Parser $parser, TokensList $list ) : void

Описание методов

build() публичный Метод

public build ( ) : string
Результат string

parse() публичный Метод

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.
Результат void

Описание свойств

$OPTIONS публичное статическое свойство

Options for INSERT statements.
public static array $OPTIONS
Результат array

$into публичное свойство

Tables used as target for this statement.
public IntoKeyword,SqlParser\Components $into
Результат SqlParser\Components\IntoKeyword

$onDuplicateSet публичное свойство

If ON DUPLICATE KEY UPDATE clause is present holds the SetOperation
public SetOperation[],SqlParser\Components $onDuplicateSet
Результат SqlParser\Components\SetOperation[]

$select публичное свойство

If SELECT clause is present holds the SelectStatement
public SelectStatement,SqlParser\Statements $select
Результат SelectStatement

$set публичное свойство

If SET clause is present holds the SetOperation
public SetOperation[],SqlParser\Components $set
Результат SqlParser\Components\SetOperation[]

$values публичное свойство

Values to be inserted.
public Array2d,SqlParser\Components $values
Результат SqlParser\Components\Array2d