/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 vote270 views2 answers
Laravel collection implode
PHP Laravel
2 votes285 views6 answers
Laravel get query parameters
PHP Laravel
1 vote270 views1 answer
Why storage link do not work in host for laravel
PHP Laravel
0 vote254 views1 answer
Laravel where search like with space
PHP Laravel
0 vote288 views1 answer
Validate file count with validate in laravel
PHP Laravel
0 vote277 views1 answer
Laravel validation unique if this field is changed
PHP Laravel
3 votes290 views6 answers
Add to collection laravel
PHP Laravel
0 vote312 views1 answer
Test lockForUpdate laravel
PHP Laravel
22 votes265 views5 answers
Update or insert in laravel
PHP Laravel
5 votes267 views2 answers
Laravel migration price
PHP Laravel