Skip to content

yevgen-grytsay/yii2-mysql-limit-delete

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Limited rows DB delete query

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();

About

Allows use LIMIT clause in a DELETE query

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages