PHP 클래스 phprs\ezsql\rules\insert\OnDuplicateKeyUpdateRule

상속: extends phprs\ezsql\rules\basic\ExecRule
파일 보기 프로젝트 열기: caoym/phprs-restful

공개 메소드들

메소드 설명
__construct ( $context )
onDuplicateKeyUpdate ( string $column, mixed $value ) : ExecRule insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdate('a', Sql::native('a+1')) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
onDuplicateKeyUpdateArgs ( $values ) : ExecRule insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateArgs(['a'=>Sql::native('a+1')]) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
onDuplicateKeyUpdateExpr ( $expr, $_ = null ) : ExecRule insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateExpr('a=a+1') => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"

메소드 상세

__construct() 공개 메소드

public __construct ( $context )

onDuplicateKeyUpdate() 공개 메소드

insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdate('a', Sql::native('a+1')) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
public onDuplicateKeyUpdate ( string $column, mixed $value ) : ExecRule
$column string
$value mixed
리턴 phprs\ezsql\rules\basic\ExecRule

onDuplicateKeyUpdateArgs() 공개 메소드

insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateArgs(['a'=>Sql::native('a+1')]) => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
public onDuplicateKeyUpdateArgs ( $values ) : ExecRule
리턴 phprs\ezsql\rules\basic\ExecRule

onDuplicateKeyUpdateExpr() 공개 메소드

insertInto('table') ->values(['a'=>1, 'b'=>Sql::native('now()')]) ->onDuplicateKeyUpdateExpr('a=a+1') => "INSERT INTO table(a,b) VALUES(1,now()) ON DUPLICATE KEY UPDATE a=a+1"
public onDuplicateKeyUpdateExpr ( $expr, $_ = null ) : ExecRule
리턴 phprs\ezsql\rules\basic\ExecRule