Oracle數(shù)據(jù)庫
? ? ? ? 方式一（推薦）
-- 將 t2表的字段更新到t1表
MERGE INTO COMMUNITY_MEMBER_APPLY_DIE T1
USING COMMUNITY_MEMBER T2
ON (T1.MEMBER_ID = T2.MEMBER_ID)
WHEN MATCHED THEN
? ? UPDATE
? ? SET T1.REAL_NAME = T2.USER_NAME,
? ? ? ? T1.CARD_NUM=T2.CARDNUM
? ? where T1.CARD_NUM is null
? ? ? ?or T1.REAL_NAME is null;? ? ? ? 方式二
-- 將 t2表的字段更新到t1表
update COMMUNITY_MEMBER_APPLY_DIE T1
set (REAL_NAME, CARD_NUM)
? ? ? ? = (select T2.USER_NAME, T2.CARDNUM from COMMUNITY_MEMBER T2 where T1.MEMBER_ID = T2.MEMBER_ID)
where T1.CARD_NUM is null
? ?or T1.REAL_NAME is null;????????方式一比方式二效率快很多文章來源地址http://www.zghlxwxcb.cn/news/detail-731330.html
MySQL數(shù)據(jù)庫?
-- 將 t2表的字段更新到t1表
update org T1, community_area T2
set T1.prov=T2.province,
T1.city=T2.city,
T1.dist=T2.district,
T1.street=T2.town,
T1.community=T2.village
where T1.area_code = T2.area_code;文章來源：http://www.zghlxwxcb.cn/news/detail-731330.html
到了這里，關(guān)于數(shù)據(jù)庫將一張表中的數(shù)據(jù)更新到另一張表（Oracle、MySQL）的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
