yevgen-grytsay/yii2-mysql-limit-delete

Allows use LIMIT in DELETE query

dev-master 2020-12-03 21:06 UTC

Requires

• yiisoft/yii2: *

Requires (Dev)

• phpunit/phpunit: ~4.0

MIT

• Yevgen Grytsay

• extension
• yii2

README

Allows use LIMIT clause in a DELETE query

Installation

The preferred way to install this extension is through composer.

Either run

php composer.phar require --prefer-dist yevgen-grytsay/yii2-mysql-limit-delete "*"

or add

"yevgen-grytsay/yii2-mysql-limit-delete": "*"

to the require section of your composer.json file.

Usage

Once the extension is installed, simply use it in your code by :

/** @var \yii\db\Connection $conn */
/** @var \yii\db\mysql\QueryBuilder $qb */
$deleteQb = new \YevgenGrytsay\Yii2DbLimitedDelete\DeleteQuery($conn, $qb);
$command = $deleteQb->delete('table', ['=', 'host', 'packagist.org'], 100);
$command->execute();