/PHP/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

2 votes302 views1 answer
Symfony doctrine existing database
PHP Symfony
1 vote220 views1 answer
Add user meta
PHP
16 votes213 views4 answers
Laravel auth helper function
PHP
0 vote218 views2 answers
Xyz
PHP
44 votes224 views4 answers
Laravel random string
PHP Laravel
0 vote203 views1 answer
How to change directory in command processor
PHP
0 vote211 views1 answer
Laravel include files
PHP
9 votes220 views4 answers
Composer require laravel/ui for laravel 6
PHP Laravel
0 vote261 views1 answer
Laravel 8 date difference in days
PHP Laravel
0 vote223 views1 answer
Nmc
PHP