Yii2. How to change the value of an attribute for all records in a table?

Question

Yii

I do like this:

$models = Table::findAll(['type'=>$type]);
        foreach ($models as $model) {
            $model->value = 0;
            $model->save();
        }

But it reeks of some kind of bullshit. Too many requests if there are many entries. Is there any way to optimize?

Answer 1

from off. docs www.yiiframework.com/doc-2.0/yii-db-activerecord.h ...

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

Answer 2

Throw a simple PDO request for Update