/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

3 votes124 views5 answers
Laravel permission
PHP Laravel
3 votes133 views1 answer
Laravel middleware route
PHP Laravel
0 vote203 views1 answer
String length laravel validation
PHP Laravel
0 vote130 views2 answers
Laravel validation exact string length
PHP Laravel
3 votes136 views1 answer
Sum multiple fields separately in laravel
PHP Laravel
8 votes169 views5 answers
Laravel route is current route
PHP Laravel
9 votes124 views3 answers
Laravel validation image or file
PHP Laravel
2 votes138 views3 answers
Laravel 8 404 status
PHP Laravel
0 vote128 views1 answer
Rawbetween in laravel
PHP Laravel
8 votes135 views4 answers
Laravel get all session data
PHP Laravel