/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 vote161 views1 answer
Forelse in laravel
PHP Laravel
23 votes180 views4 answers
Laravel change foreign key name
PHP Laravel
0 vote166 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
29 votes173 views6 answers
Where like laravel
PHP Laravel
1 vote179 views1 answer
Datediff in hour query builder laravel
PHP Laravel
0 vote184 views1 answer
Implement class in autoloader athow to implment data table in laravel project
PHP Laravel
5 votes171 views3 answers
Laravel destroy session
PHP Laravel
0 vote188 views2 answers
Laravel bootstrap nav active
PHP Laravel
0 vote168 views1 answer
Displaying laravel error in below input field
PHP Laravel
3 votes199 views5 answers
Laravel request has
PHP Laravel