/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 vote405 views3 answers
Writing into the database with one click laravel
PHP Laravel
1 vote376 views1 answer
Laravel select all except some columns
PHP Laravel
0 vote400 views4 answers
Installing bootstrap ui in laravel app
PHP Laravel
1 vote365 views4 answers
Laravel get route path uri
PHP Laravel
1 vote380 views1 answer
Laravel set config value runtime
PHP Laravel
0 vote364 views1 answer
Update function laravel 7
PHP Laravel
4 votes357 views3 answers
Laravel description substring
PHP Laravel
1 vote326 views1 answer
Trim laravel
PHP Laravel
0 vote362 views1 answer
Laravel redis sentinel
PHP Laravel
1 vote365 views1 answer
Config clear laravel
PHP Laravel