/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 vote141 views2 answers
Laravel db insert get last id
PHP Laravel
0 vote144 views2 answers
Laravel roles and permissions
PHP Laravel
0 vote179 views1 answer
Laravel request not returning errors
PHP Laravel
0 vote157 views1 answer
Laravel token logout
PHP Laravel
0 vote155 views1 answer
Disable laravel passport
PHP Laravel
0 vote165 views2 answers
Laravel set middleware default
PHP Laravel
2 votes144 views2 answers
Laravel 5.8 cors
PHP Laravel
0 vote143 views1 answer
Why phpunit don't work in commend laravel
PHP Laravel
26 votes144 views6 answers
Laravel validation integer
PHP Laravel
0 vote147 views1 answer
Laravel asset resolving to http not https
PHP Laravel