/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

0 vote293 views1 answer
Laravel permit only some inputs
PHP Laravel
0 vote293 views1 answer
Laravel eloquent many to many query using whereHas
PHP Laravel
0 vote351 views2 answers
Laravel composite unique key
PHP Laravel
0 vote252 views1 answer
Laravel truncate string laravel 8
PHP Laravel
0 vote288 views1 answer
Laravel openstreetmap
PHP Laravel
3 votes302 views2 answers
How to change laravel port
PHP Laravel
2 votes296 views3 answers
How to share a helper globally laravel
PHP Laravel
0 vote283 views1 answer
Delete a single record in laravel 5
PHP Laravel
0 vote299 views1 answer
How show livewire component in laravel
PHP Laravel
-1 vote273 views1 answer
Laravel hide columns
PHP Laravel