/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

3 votes121 views1 answer
Php loop through every day of the year
PHP
3 votes136 views2 answers
Php check folder exists and create
PHP
0 vote119 views1 answer
Php remove directory only if empty
PHP
3 votes125 views1 answer
Column not found: 1054 Unknown column 'updated_at'
PHP
0 vote142 views1 answer
Laravel mail success or failure
PHP Laravel
1 vote151 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
0 vote141 views1 answer
How check the time of operation in laravel
PHP
0 vote131 views1 answer
How to use union and intersection in laravel query
PHP Laravel
11 votes136 views3 answers
Require password confirm laravel
PHP Laravel
0 vote159 views1 answer
File viewer codeigniter
PHP CodeIgniter