/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

0 vote188 views3 answers
Laravel how to fetch user from user model based on id from post
PHP Laravel
0 vote210 views1 answer
Laravel uuid not showing in query
PHP Laravel
20 votes193 views6 answers
Laravel validation types
PHP Laravel
0 vote222 views1 answer
Laravel route limit parameter
PHP Laravel
0 vote195 views1 answer
Laravel change error page to open in vscode
PHP Laravel
0 vote217 views3 answers
Database and files backup laravel
PHP Laravel
0 vote174 views2 answers
How to update dropdown value in laravel
PHP Laravel
0 vote184 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
2 votes250 views2 answers
Sentence get first second word php laravel
PHP Laravel
0 vote189 views1 answer
Laravel datatable render html
PHP Laravel