Simple (hopefully) MySQL query

[NoFear]

Ok, this is going to seem really stupid (that is, if it can even be done), but I just can't get it to work.

I need to update about 20 different tables all at one time, where a user modified some inupt.

For example - I need to subract
'x' from table_1, column_1,
'y' from table_2 column_1, and
'z' from table_3, column_1
where user_id = 'user_whatever'

Can anybody help me out?? Thanks!

[NoFear]

This is what I tried, and it's not working:

update asset1, asset2
SET asset1.hour_1 = asset1.hour_1+5,
asset2.hour_1 = asset2.hour_1+5
where asset1.user_id = 123;

[diego25]

Why not have it in multiple queries?

Diego

[NoFear]

If I did that, I would be making 20+ hits on the database for each occurance of this situation. That would be an incredible hit on the database, and I was hoping that I could do it in one shot as to make it less resource-consuming.