/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

1 vote132 views2 answers
How to remove token while logout using laravel 8
PHP
0 vote156 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
7 votes175 views3 answers
How to remove public from url in laravel 8
PHP Laravel
0 vote184 views1 answer
Laravel count data wise
PHP Laravel
2 votes152 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
3 votes101 views1 answer
Tutorial laravel alert
PHP
0 vote135 views1 answer
Opencart add custom description meta tag using controller file
PHP
8 votes160 views6 answers
Print last query in codeigniter
PHP
13 votes129 views6 answers
Laravel delete
PHP
0 vote129 views1 answer
Delete a single record in laravel 5
PHP