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] ... ]
파일 보기
프로젝트 열기: phpmyadmin/sql-parser
공개 프로퍼티들
프로퍼티 |
타입 |
설명 |
|
$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 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[] |
|
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[] |
|
public Array2d,SqlParser\Components $values |
리턴 |
SqlParser\Components\Array2d |
|