/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 vote256 views1 answer
Laravel resourece type
PHP Laravel
6 votes258 views2 answers
Installing livewire on laravel v6
PHP Laravel
3 votes176 views2 answers
Laravel custom paginator links view
PHP Laravel
1 vote240 views1 answer
Laravel helper function for check string is exist in another string
PHP Laravel
2 votes244 views2 answers
Laravel foreach first
PHP Laravel
3 votes252 views2 answers
Laravel create project thorugh composer
PHP Laravel
0 vote222 views1 answer
Throw 403 laravel
PHP Laravel
5 votes224 views2 answers
Laravel auth namespace
PHP Laravel
0 vote235 views2 answers
Laravel bootstrap nav active
PHP Laravel
1 vote244 views1 answer
How validate the becrypt password in laravel
PHP Laravel