/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

6 votes267 views2 answers
Laravel migration make column nullable
PHP
4 votes306 views2 answers
How to rename a table element in laravel
PHP Laravel
0 vote255 views1 answer
Enable tab completion in terraform
PHP
1 vote283 views1 answer
How to take last entry in database in laravel Method ONe
PHP
17 votes270 views4 answers
Php title case
PHP
1 vote285 views1 answer
Check if post id exists wordpress
PHP
0 vote279 views1 answer
Get post php
PHP
1 vote303 views2 answers
Wordpress login programmatically
PHP Wordpress
0 vote307 views1 answer
Search WordPress with custom field
PHP Wordpress
22 votes291 views6 answers
Laravel where like
PHP