/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

6 votes288 views3 answers
Laravel route namespace
PHP Laravel
3 votes314 views2 answers
Laravel tinker update password
PHP Laravel
0 vote309 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
0 vote431 views1 answer
Laravel one session per user
PHP Laravel
8 votes316 views1 answer
Laravel sotrage linkl
PHP Laravel
-1 vote320 views2 answers
Laravel OrderBy on Eloquent whereHas relationship
PHP Laravel
0 vote324 views2 answers
How to back the page laravel where the scorll is
PHP Laravel
1 vote286 views1 answer
Select selected fields in laravel join
PHP Laravel
1 vote287 views1 answer
Laravel descending order paginate eloquent
PHP Laravel
8 votes319 views6 answers
Define table name in model laravel
PHP Laravel