/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

5 votes220 views6 answers
Sync laravel
PHP Laravel
1 vote234 views1 answer
Maximum execution time of 60 seconds exceeded laravel 8
PHP Laravel
2 votes202 views3 answers
Laravel blade time difference
PHP Laravel
0 vote262 views1 answer
Laravel display old value in form
PHP Laravel
0 vote231 views2 answers
How to update dropdown value in laravel
PHP Laravel
2 votes242 views2 answers
Send multiple attachment in mail laravel 8
PHP Laravel
0 vote226 views1 answer
Laravel Filesystem chmod(): Operation not permitted
PHP Laravel
6 votes204 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
39 votes253 views6 answers
Laravel foreign key constraint
PHP Laravel
0 vote165 views1 answer
If notexists in laravel query
PHP Laravel