0C03HnNv

1START TRANSACTION;
2CREATE TEMPORARY TABLE IF NOT EXISTS customer_account.tmp_customer
3AS (SELECT customer_id,
4           multi_max_stake,
5           max_stake,
6           cumulative_stake_limit
7    FROM customer_account.customer);
8UPDATE tmp_customer
9SET multi_max_stake=10000
10WHERE multi_max_stake = 5000
11  AND max_stake = 5000
12  AND cumulative_stake_limit = 15000;
13
14UPDATE customer_account.customer dest, tmp_customer src
15SET dest.multi_max_stake=src.multi_max_stake
16WHERE dest.customer_id = src.customer_id;
17COMMIT;