mysql 多表关联修改数据

最新推荐文章于 2024-01-18 10:30:08 发布

Json159

最新推荐文章于 2024-01-18 10:30:08 发布

阅读量2k

点赞数

本文链接：https://blog.csdn.net/Json159/article/details/127545020

版权

数据库专栏收录该内容

29 篇文章 2 订阅

订阅专栏

/* 更新账户字段 */

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';