/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 vote158 views1 answer
Laravel controller constructor auth user null
PHP Laravel
1 vote166 views2 answers
How to pass parameter in routes of laravel
PHP Laravel
0 vote154 views1 answer
Laravel price database
PHP Laravel
0 vote169 views1 answer
Laravel array length
PHP Laravel
0 vote168 views1 answer
Laravel set innodb scema builder
PHP Laravel
0 vote215 views1 answer
Laravel app running in console
PHP Laravel
0 vote181 views4 answers
How to host laravel project on local server
PHP Laravel
5 votes137 views1 answer
Bootstrap blade pagination
PHP Laravel
1 vote155 views1 answer
Delete record using laravel
PHP Laravel
42 votes238 views6 answers
Laravel cache remember
PHP Laravel