Mysql update table using webpy

Question

I want the below query to implement in webpy using db.update

  update emp set age=age+1 where x=1`

When i tried

 db.update('emp',where='x=1',age=age+1)

This throw me an error saying global name 'age' is not defined

pigletfly · Accepted Answer · 2015-04-08 03:16:26Z

1

You should use db.query instead,like this results = db.query("UPDATE emp SET age=age+1 WHERE x=$x", vars={'x':1})

answered Apr 8, 2015 at 3:16

pigletfly

1,0811 gold badge17 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks man. I had figure that out long back, but still there will be people like me. For future use ;)