/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

9 votes189 views1 answer
Laravel 6 link storage with public
PHP Laravel
4 votes170 views5 answers
Laravel array_pluck
PHP Laravel
3 votes179 views2 answers
Laravel add values to request
PHP Laravel
0 vote199 views1 answer
Laravel firstorcreate with multiple parameters
PHP Laravel
1 vote237 views1 answer
How login with phone in laravel
PHP Laravel
5 votes167 views4 answers
Laravel model wherein
PHP Laravel
1 vote159 views1 answer
Laravel remove apostrophe variables
PHP Laravel
2 votes201 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel
0 vote185 views1 answer
Laravel 8 - get values of url query strings in controller
PHP Laravel
3 votes177 views1 answer
Run laravel cron job on cpanel
PHP Laravel