/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

0 vote411 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
-1 vote342 views1 answer
Excel extract date from dd mm yyyy laravel blade
PHP Laravel
3 votes457 views2 answers
Associate laravel
PHP Laravel
-1 vote456 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote364 views1 answer
Laravel validatrion check should be null
PHP Laravel
1 vote373 views1 answer
Laravel 8 $request->intersect not working
PHP Laravel
3 votes374 views2 answers
Error handling in laravel
PHP Laravel
1 vote375 views2 answers
Get the value without setter method laravel
PHP Laravel
1 vote395 views1 answer
Laravel mongodb field delete (key delete) (column delete) drop
PHP Laravel
0 vote351 views1 answer
Laravel components scripts
PHP Laravel