/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 votes195 views3 answers
Laravel with select
PHP Laravel
14 votes223 views6 answers
How to install laravel
PHP Laravel
0 vote216 views1 answer
Laravel telescope redirect to localhost
PHP Laravel
0 vote340 views1 answer
Touches in laravel
PHP Laravel
1 vote253 views1 answer
How refresh the record of data in laravel
PHP Laravel
0 vote199 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel
8 votes316 views2 answers
Laravel drop multiple columns
PHP Laravel
1 vote200 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote216 views1 answer
What is actullay work model in laravel
PHP Laravel
0 vote206 views1 answer
Current time input field in laravel form
PHP Laravel