/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

0 vote162 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
0 vote145 views1 answer
Add line in string column export php
PHP
2 votes126 views1 answer
Wp get term link
PHP
0 vote153 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP
-1 vote180 views2 answers
Laravel pagination keep query string
PHP Laravel
0 vote152 views1 answer
Laravel withValidator
PHP
0 vote141 views1 answer
Calculate 18 years back date in php
PHP
0 vote132 views1 answer
Custom my account page woocommerce
PHP
0 vote147 views4 answers
Installing bootstrap ui in laravel app
PHP
0 vote147 views1 answer
How to style echo in php
PHP