How to do batchUpdate in yii2

yii2 query-builder batch-updates
sapo picture sapo · Apr 17, 2015 · Viewed 13k times · Source

Only batchInsert is available in yii2, bacthUpdate is not available in yii2, how can we do this in yii2 like Codeigniter batchUpdate?

Answer

Mike Kaharlykskiy picture Mike Kaharlykskiy · Mar 17, 2018

Use updateAll() on your model.

Customer::updateAll(['status' => 1], 'status = 2');

From Yii 2 documentation

Hope it helps!

Related questions

Yii2: update field with query builder

How can I update field with query builder in Yii2? I can't find this in documentation. Thanks! UPD This is the solution: // UPDATE $connection = Yii::$app->db; $connection->createCommand()->update('user', ['status' => 1], 'age > 30')…

Read More
yii2 ActiveQuery 'OR LIKE' filter

i have a task - add to search model searching by full name. Full name is first name + last name. So i need to build query like WHERE first_name LIKE '%var%' OR last_name LIKE '%var%…

Read More
How to make a drop down list in yii2?

How to make a dropdown in yii2 using an activeform and a model? Since all the methods has changed in yii2,how it is done in the new one?

Read More