/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 vote372 views1 answer
Can i do a relation between 2 coulnm in mongodb laravel
PHP Laravel
0 vote338 views2 answers
Laravel pagination vuetify
PHP Laravel
2 votes360 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel
0 vote361 views3 answers
Convert object to array laravel
PHP Laravel
1 vote396 views3 answers
Laravel eloquent where date today
PHP Laravel
0 vote344 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel
1 vote348 views1 answer
Laravel add auto increment
PHP Laravel
0 vote366 views1 answer
How to update request all value in laravel controller before save in database
PHP Laravel
0 vote335 views2 answers
Laravel date format valdiate
PHP Laravel
12 votes360 views2 answers
Get current authenticated user laravel
PHP Laravel