/* 更新账户字段 */
UPDATE sfc_order_account one, sfc_order_account_test test set one.app_info = test.app_info WHERE one.id=test.id and one.platform='my' AND test.platform = 'my';
/* 新增 token */
INSERT INTO sfc_order_account_token_test2 ( platform, token_key, access_token, refresh_token, expires_at ) SELECT
platform,
token_key,
access_token,
refresh_token,
expires_at
FROM
sfc_order_account_token_test
WHERE
NOT EXISTS ( SELECT * FROM sfc_order_account_token_test2 WHERE sfc_order_account_token_test2.token_key = sfc_order_account_token_test.token_key) AND sfc_order_account_token_test.platform = 'jumia';
更新 线上token
UPDATE sfc_order_account_token_copy1 one,
sfc_order_account_token_test test
SET one.refresh_token = test.refresh_token, one.token=test.token
WHERE
one.id = test.id
AND one.platform = 'my'
AND test.platform = 'my';