search

knex / knex

A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
https://knexjs.org/
MIT License
19.16k stars 2.11k forks source link

update query? #129

Closed oliverzy closed 10 years ago

oliverzy commented 10 years ago

Hi,

I found it is impossible to build the following query: update schema_version set version_rank = version_rank + 1 where version_rank >= 198

the version_rank column is int(11) type (mysql).

And it looks like update cannot use raw expression as well

bendrucker commented 10 years ago

http://knexjs.org/#Builder-increment

knex('tableName').where('version_rank', '>=', 198).increment('version_rank')