mysqli UNION 以正确的列名获取数据

Question

我想用 UNION 从数据库中获取数据，我将链接定义为新闻链接，并将图片定义为文章图片，但它在新闻链接列下显示文章图片数据，我该如何解决这个问题？

SELECT * FROM
((SELECT date, link as newslink FROM news ORDER BY id DESC)
UNION
(SELECT date, pic as articlepic FROM article ORDER BY id DESC)) as x
ORDER BY date DESC LIMIT 6

Sample Data

我想获取articlepic栏下的articlepic数据，newslink栏下的newslink

Answer 1

如果您在不同的列中取值，则必须在选择中为不对应的列添加空值

SELECT * FROM
 ((SELECT date, link as newslink, null as articlepic 
  FROM news ORDER BY id DESC)
UNION
 (SELECT date, null, pic 
   FROM article ORDER BY id DESC)) as x
ORDER BY date DESC LIMIT 6