/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 vote359 views1 answer
Laravel retry failed transactions
PHP Laravel
0 vote345 views1 answer
Editing items in collection in laravel
PHP Laravel
6 votes439 views1 answer
Laravel add attribute migration column
PHP Laravel
1 vote341 views5 answers
Laravel modules
PHP Laravel
1 vote377 views2 answers
Laravel eloquent with query extra parameter
PHP Laravel
2 votes356 views3 answers
Laravel get file size uploaded
PHP Laravel
1 vote352 views1 answer
Laravel blade form old value
PHP Laravel
5 votes370 views2 answers
Collection laravel filter
PHP Laravel
0 vote356 views1 answer
Laravel count data wise
PHP Laravel
0 vote336 views1 answer
WhereJsonContains laravel
PHP Laravel