/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 votes205 views4 answers
Get first day of current month php
PHP
0 vote191 views1 answer
Drupal 9 Get taxonomy term objects by vocabulary machine name vid
PHP
8 votes229 views3 answers
Route parameter type laravel
PHP Laravel
7 votes209 views2 answers
Laravel get session variable in controller
PHP
1 vote237 views1 answer
Symfony call another controller
PHP Symfony
2 votes210 views2 answers
Route:: "resourceverbs([]);" Class 'App\Providers\Route' not found
PHP
0 vote204 views1 answer
Publish laravel scout
PHP
2 votes203 views3 answers
Call stored procedure in laravel
PHP
4 votes225 views2 answers
Check request header laravel
PHP Laravel
0 vote194 views1 answer
Php pdo like
PHP