/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 vote129 views1 answer
Laravel if elseon join
PHP Laravel
4 votes127 views3 answers
Laravel on delete set null
PHP Laravel
2 votes126 views3 answers
How to change the colum type in migration laravel
PHP Laravel
49 votes158 views6 answers
Laravel add column to existing table
PHP Laravel
1 vote127 views1 answer
Laravel refresh server
PHP Laravel
0 vote128 views1 answer
Laravel delete controller still cached
PHP Laravel
2 votes125 views2 answers
Check if date between two dates laravel
PHP Laravel
0 vote133 views2 answers
Laravel rename file ftp
PHP Laravel
45 votes233 views6 answers
Laravel run seeder
PHP Laravel
0 vote122 views2 answers
Laravel permission to vuejs
PHP Laravel