/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

1 vote338 views3 answers
Laravel invoice toturial
PHP Laravel
0 vote394 views1 answer
How to make:trait in commend line in laravel
PHP Laravel
7 votes349 views6 answers
Get current route laravel
PHP Laravel
4 votes338 views3 answers
Laravel on delete set null
PHP Laravel
6 votes354 views2 answers
Generate application key laravel
PHP Laravel
31 votes312 views6 answers
Update or create laravel
PHP Laravel
0 vote346 views2 answers
Laravel validation exact string length
PHP Laravel
0 vote316 views1 answer
Php laravel convert blob type to string
PHP Laravel
7 votes356 views2 answers
Transaction commit rollback in laravel
PHP Laravel
2 votes351 views3 answers
Laravel env production
PHP Laravel