Sunday 28 May 2017

mysql knex math operation

Im using knex with node.js I want to do a math query

I want to do this in knex
UPDATE fares SET fare=fare + 70

This is my query in knex, all I get is 0 in the database

knex('table').update({ fares: 'fares' + 70}).then(function() {});



via Morris S

No comments:

Post a Comment