/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 vote265 views1 answer
Laravel make:action
PHP Laravel
2 votes274 views1 answer
Laravel difference between current time and created time
PHP Laravel
2 votes252 views3 answers
Laravel migration drop foreign keys
PHP Laravel
0 vote192 views2 answers
Laravel restrict home route access
PHP Laravel
0 vote240 views1 answer
Laravel collection times
PHP Laravel
0 vote234 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote252 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
0 vote237 views1 answer
String length laravel validation
PHP Laravel
3 votes298 views2 answers
Laravel Migrations from an existing database
PHP Laravel
0 vote244 views2 answers
Laravel sanctum instalation
PHP Laravel