The stats have an 'a' in front of them. Without testing, it will be something like:
Code:
UPDATE items SET astr = astr * 2, asta = asta * 2, aagi = aagi * 2, adex = adex * 2;
Also, most likely mySQL will allow you to use *= if you want. Like: astr *= 2