更新查询出来的信息

UPDATE exchange_customer_account AS a
INNER JOIN (
    SELECT
        available,
        user_id
    FROM
        exchange_customer_account
    WHERE
        available > 0
    AND coin_code = 'QOO'
) AS b ON a.user_id = b.user_id
AND coin_code = 'QO'
SET a.available = b.available * 1.09