/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

7 votes135 views2 answers
How to start composer in laravel project on localhost
PHP Laravel
0 vote170 views1 answer
Laravel Filesystem chmod(): Operation not permitted
PHP Laravel
0 vote140 views2 answers
Laravel allow all fillable
PHP Laravel
29 votes134 views6 answers
Where like laravel
PHP Laravel
0 vote159 views1 answer
Adding another return message from Laravel Livewire
PHP Laravel
1 vote139 views2 answers
Url segment in laravel
PHP Laravel
0 vote135 views1 answer
Laravel hiding attributes JSON
PHP Laravel
1 vote141 views1 answer
Laravel websockets onsubscribe
PHP Laravel
7 votes146 views2 answers
Laravel field types from database field type
PHP Laravel
1 vote176 views1 answer
How to add property to the request object in laravel
PHP Laravel