How to delete specific column value from db in yii2

Question

I want to delete updated value from db. Like if the notice is inserted of notice column in class table and I want to delete it. So what will be the query in yii2? Please help -

$model = Class::find()->where('id', $id)->one;
$model->delete();

Above query is for -

DELETE FROM class WHERE id = $id;

I want to write query like that in yii2 -

DELETE notice FROM class WHERE id = $id;

anfen · Accepted Answer · 2019-02-06 16:32:50Z

1

If you are searching using the primary key, you can use

$model = Class::findOne($id);

Then, for deleting (setting to null) the notice field, you just need to use

$model->notice = NULL;
$model->save();

Note that if the notice attribute is required, or not null, the save will fail.

answered Feb 6, 2019 at 16:32

anfen

3883 silver badges6 bronze badges

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

Comments

Deus chami · Accepted Answer · 2019-02-07 10:40:00Z

0

Yii allows you to execute SQL command direct https://www.yiiframework.com/doc/api/2.0/yii-db-command

$query = "DELETE notice FROM class WHERE id = {$id}";
Yii::$app->db->createCommand($query)->execute();

answered Feb 7, 2019 at 10:40

Deus chami

528 bronze badges

Collectives™ on Stack Overflow

How to delete specific column value from db in yii2

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related