/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

1 vote232 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel
0 vote285 views1 answer
Laravel unique funcation
PHP Laravel
0 vote227 views1 answer
Laravel random value from array
PHP Laravel
12 votes221 views3 answers
Laravel db::query update
PHP Laravel
0 vote283 views1 answer
Laravel simplexmlelement not found
PHP Laravel
3 votes237 views3 answers
Laravel notification
PHP Laravel
14 votes218 views4 answers
Laravel set timezone dynamically
PHP Laravel
3 votes272 views2 answers
Laravel model exists id
PHP Laravel
5 votes216 views3 answers
Return view controller laravel
PHP Laravel
1 vote247 views1 answer
Groupby in laravel with count
PHP Laravel