Méthode |
Description |
|
__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" |
|