해바라기 노래

mysql -u root -p upbit_data -e \\\\\\\"
UPDATE stats_direction_01_1m a
JOIN (
    SELECT cur.wr_id,
        CASE WHEN (cur.side_plus - IFNULL(prv.side_plus, cur.side_plus)) > (cur.side_minus - IFNULL(prv.side_minus, cur.side_minus)) THEN 1 ELSE 0 END AS new_plus_cnt,
        CASE WHEN (cur.side_minus - IFNULL(prv.side_minus, cur.side_minus)) > (cur.side_plus - IFNULL(prv.side_plus, cur.side_plus)) THEN -1 ELSE 0 END AS new_minus_cnt
    FROM stats_direction_01_1m cur
    LEFT JOIN stats_direction_01_1m prv
        ON prv.market = cur.market
        AND prv.wr_id = (SELECT MAX(p.wr_id) FROM stats_direction_01_1m p WHERE p.market = cur.market AND p.wr_id < cur.wr_id)
) b ON a.wr_id = b.wr_id
SET a.side_plus_cnt = b.new_plus_cnt, a.side_minus_cnt = b.new_minus_cnt;
\\\\\\\"