I have two tables that need the exact same values for denormalization purposes.
Here's the query.
UPDATE Table_One SET win = win+1, streak = streak+1, score = score+200 WHERE userid = 1 AND lid = 1 LIMIT 1
UPDATE Table_Two SET win = win+1, streak = streak+1, score = score+200 WHERE userid = 1 LIMIT 1
As you can see the only difference between both tables is their name and table two doesn't have the field
Anyway to combine both updates to just one?