/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

2 votes483 views1 answer
Yii2 migration add column
PHP Yii
2 votes305 views1 answer
Laravel artisan create criteria
PHP
0 vote331 views2 answers
Sort names alphabetically php
PHP
0 vote282 views1 answer
What was the old name of PHP?
PHP
1 vote345 views1 answer
How to alias table name in laravel model
PHP Laravel
0 vote368 views1 answer
How to display limited post content in wordpress
PHP Wordpress
0 vote311 views1 answer
Laravel controller create command in a folder
PHP
0 vote245 views1 answer
Symony type request
PHP
0 vote316 views1 answer
Avoid grouping databases in phpmyadmin
PHP
0 vote324 views1 answer
Acf wordpress loop through and display blog posts order by date and type
PHP