/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

24 votes194 views2 answers
How to use join in laravel 5.4
PHP Laravel
0 vote139 views1 answer
Php percent sign
PHP
0 vote178 views1 answer
Contact us page mail prestashop
PHP
0 vote176 views1 answer
Indian time laravel
PHP
2 votes170 views2 answers
Get session id in laravel
PHP
0 vote190 views1 answer
Display data from two dimensional array in vew laravel
PHP Laravel
1 vote199 views1 answer
Laravel word count utf8
PHP Laravel
45 votes208 views6 answers
Laravel run seeder
PHP
0 vote189 views1 answer
Laravel take value from different array by key
PHP Laravel
2 votes130 views2 answers
Laravel get count group by
PHP