649
批量更新重複數據
原因：重負注冊老鄉會會員日誌，增加 400積分。
解決：設置該積分0
UPDATE sz_app_credit_log AS a
LEFT JOIN (SELECT uid,lid,MIN(lid) FROM sz_app_credit_log
WHERE appid=7 and oreason LIKE '%老鄉會會%'
AND dateline>=UNIX_TIMESTAMP('2011-10-01') AND dateline<UNIX_TIMESTAMP('2011-11-01')
GROUP BY uid HAVING COUNT(1)>1 ORDER BY uid ) AS b
ON a.uid=b.uid
SET a.ovalue=0,a.oreason='注冊老鄉會會員_錯誤'
WHERE a.lid>b.lid and appid=7
AND a.dateline>=UNIX_TIMESTAMP('2011-10-01') AND a.dateline<UNIX_TIMESTAMP('2011-11-01')
最後更新：2017-04-02 06:52:05