Adding values in database with query in laravel

Question

I want to add 10 from a current database value. Current db value = 20;adding = 10;updated value 30; The following code is not working. DB::table('employee')->increment('bonus'=>'bonus+10');

try this: Employee::find($employee_id)->increment('bonus', 10); — Kannan K
– Kannan K, Commented Sep 13, 2017 at 5:13

Kannan K · Accepted Answer · 2017-09-13 05:18:16Z

1

Try this:

DB::table('employee')->increment('bonus', 10);

answered Sep 13, 2017 at 5:18

Kannan K

4,4891 gold badge15 silver badges27 bronze badges

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

Comments

Suniti Yadav · Accepted Answer · 2017-09-13 05:17:58Z

0

Try this -

DB::table('employee')->increment('bonus', 10);

You can do like this as well:

DB::table('employee')
   ->where('rowID', 1) // if you to add in a perticular table else comment it for updating entire column's value by adding 10 in it.
   ->update([
       'bonus' => DB::raw('bonus + 10'),
   ]);

Hope this will help you.

answered Sep 13, 2017 at 5:17

Suniti Yadav

4033 silver badges8 bronze badges

Collectives™ on Stack Overflow

Adding values in database with query in laravel

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