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] ... ]
Показать файл
Открыть проект
Открытые свойства
Свойство |
Тип |
Описание |
|
$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 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 |
|
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 |
|
If SET clause is present
holds the SetOperation
public SetOperation[],SqlParser\Components $set |
Результат |
SqlParser\Components\SetOperation[] |
|
$values публичное свойство
public Array2d,SqlParser\Components $values |
Результат |
SqlParser\Components\Array2d |
|