Mysql怎么合并两张表

Question

求问sql语句怎么写

Answer 1

获取最终的值

select a.id, if(a.content is null, b.content, a.content) as content from a left join b on a.link = b.id;

将这个当成临时表，更新 a 即可 (这里写if，是假设a表有content字段)

update a as c,
(
  select a.id, if(a.content is null, b.content, a.content) as content 
  from a 
  left join b on a.link = b.id
) as d 
set c.content = d.content 
where d.id=c.id ;

Answer 2

SELECT [Id],[link],ISNULL((SELECT [content] FROM [Table_B] WHERE Id=[Tabe_A].[link]),'')  AS [content] FROM [Table_A]