/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 vote79 views0 answer
Laravel
PHP Laravel
0 vote117 views1 answer
Laravel response json status 500
PHP Laravel
12 votes131 views6 answers
Laravel relationship
PHP Laravel
1 vote129 views1 answer
Datediff in hour query builder laravel
PHP Laravel
15 votes134 views1 answer
Laravel skip requirements
PHP Laravel
4 votes126 views3 answers
Laravel execute command from terminal
PHP Laravel
0 vote137 views1 answer
Autogenerate slug for model laravel
PHP Laravel
-1 vote140 views1 answer
Authenticate user with phone laravel
PHP Laravel
0 vote140 views1 answer
Laravel share on whatsapp link
PHP Laravel
30 votes117 views6 answers
Laravel insert
PHP Laravel