how can you update multiple database table

Answer 1

you can use something like this: update cars as c, motors as m set c.model=2016, m.type='v8' WHERE c.id=1 and m.year=2015

Answer 2

I will try this.