/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

63 votes571 views6 answers
Laravel artisan clear cache
PHP Laravel
0 vote226 views2 answers
How to concat in where clause like laravel query builder
PHP Laravel
2 votes237 views4 answers
Laravel print query with parameters
PHP Laravel
0 vote231 views1 answer
Laravel post index method
PHP Laravel
1 vote264 views1 answer
Laravel @canany
PHP Laravel
0 vote309 views1 answer
Laravel 6 use username on url
PHP Laravel
10 votes223 views3 answers
Migrate to an existing table in laravel commad
PHP Laravel
11 votes248 views3 answers
Laravel get last 5 records
PHP Laravel
7 votes221 views2 answers
Laravel seeder with relationships
PHP Laravel
1 vote198 views1 answer
Trim laravel
PHP Laravel