How to update column value with existing column value in sequelize

[胡雪亮]

like:

update user.age = user.age+1 where id=123

try:

models.User.update({age:sequelize.col('age')+1},{where:{id:123}}).success()...

[Mick Hansen]

We actually have increment/decrement functions for atomic counters: http://sequelize.readthedocs.org/en/latest/api/instance/#incrementfields-options-promise

Other than you should be able to do something like:

```js
models.User.update({age: sequelize.literal('age + 1')}, {where: {id: 123}})
```

--

Mick Hansen

@mhansendev
mhansen.io

[Chengshu Yu]

幸亏你post了query！要不然我还要找好久！This works!