/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

48 votes379 views6 answers
Laravel join table
PHP Laravel
0 vote304 views1 answer
Get am pm 12 hour timee laravel
PHP Laravel
0 vote315 views1 answer
Laravel if elseon join
PHP Laravel
0 vote317 views1 answer
Laravel query foreach
PHP Laravel
12 votes328 views6 answers
Set session data in laravel
PHP Laravel
1 vote336 views1 answer
Using middleware auth laravel in controller constructor
PHP Laravel
0 vote341 views1 answer
How to exclude csrf in a route laravel
PHP Laravel
1 vote343 views2 answers
Public laravel htaccess
PHP Laravel
4 votes365 views5 answers
Laravel with and where
PHP Laravel
2 votes313 views3 answers
Multiple primary key defined laravel
PHP Laravel