/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 vote112 views1 answer
Require and include difference in laravel
PHP Laravel
1 vote110 views1 answer
How to alias table name in laravel model
PHP Laravel
1 vote157 views1 answer
Include a file in laravel controller
PHP Laravel
0 vote122 views1 answer
Laravel inline if else if
PHP Laravel
0 vote116 views1 answer
Failed to open stream permission denied laravel
PHP Laravel
2 votes118 views1 answer
Laravel request validation rules for create and update
PHP Laravel
1 vote114 views2 answers
Laravel 8 login logout
PHP Laravel
2 votes121 views1 answer
Laravel generate env
PHP Laravel
1 vote106 views1 answer
Laravel s3 presigned url
PHP Laravel
-1 vote110 views1 answer
Laravel merge two arrays helper
PHP Laravel