Setting attribute to NULL in Yii2 and save to database

Question

In Yii we had CDbExpression('NULL') what is the equivalent in Yii2? Need to set a database column back to null via a model in Yii2

ScaisEdge · Accepted Answer · 2016-03-17 21:34:39Z

7

If i remember correctly yii2 don't make a string conversion for null value when you can try setting the value to NULL

$model->field = NULL;

answered Mar 17, 2016 at 21:34

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

keeg · Accepted Answer · 2016-03-18 13:40:04Z

4

You can set NULL value directly to model attribute:

$model->field=null;

or config default value in rules() method

[['field'],'default',null]

keeg

3,9589 gold badges51 silver badges101 bronze badges

answered Mar 18, 2016 at 3:36

Ivoglent Nguyen

5063 silver badges9 bronze badges

The correct syntax for the rules method is: [['field'], 'default', 'value' => null],