/PHP/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

4 votes153 views1 answer
Open php ini from terminal
PHP
0 vote200 views1 answer
Laravel resourece type
PHP Laravel
1 vote127 views1 answer
Symfony migration
PHP
0 vote194 views1 answer
Laravel Http client retry request if fail
PHP Laravel
1 vote149 views1 answer
Woocommerce add custom field data to cart page
PHP
1 vote151 views4 answers
Generate random color php
PHP
0 vote162 views1 answer
Italic text in laravel notification
PHP
4 votes161 views4 answers
Carbon get day name
PHP
0 vote161 views1 answer
How to update request all value in laravel controller before save in database
PHP
0 vote193 views1 answer
Die laravel
PHP Laravel