/PHP/Laravel/Laravel increment column value in update query

Laravel increment column value in update query

DB::table('my_table')
   ->where('rowID', 1)
   ->update([
       'column1' => DB::raw('column1 + 2'),
       'column2' => DB::raw('column2 + 10'),
       'column3' => DB::raw('column3 + 13'),
       'column4' => DB::raw('column4 + 5'),
   ]);

Source: stackoverflow.com

Similar codes

2 votes200 views1 answer
Add id to route name in laravel blade
PHP Laravel
14 votes232 views2 answers
Laravel change value to intger
PHP Laravel
3 votes212 views1 answer
How to named route resource laravel
PHP Laravel
0 vote227 views2 answers
Insert multiple rows laravel
PHP Laravel
1 vote222 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote208 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP Laravel
0 vote210 views1 answer
Return view inside subfolder laravel
PHP Laravel
2 votes211 views1 answer
Laravel time to human redable format
PHP Laravel
2 votes231 views2 answers
Laravel relationship with for single data
PHP Laravel
0 vote222 views2 answers
Laravel collection search
PHP Laravel