mysql - 重用mysql中的临时表

Question

我有一个这样的查询:

(SELECT id,content,userid FROM article WHERE type='A' LIMIT 10)
UNION ALL
(SELECT c.id,c.content,c.userid FROM comment AS c
JOIN (SELECT id,content,userid FROM article WHERE type='A' LIMIT 10) AS a
ON c.articleid = a.id)

如何重用而不是重新查询此临时表SELECT id,content,userid FROMarticle WHERE type='A' LIMIT 10？

Answer 1

我将为您想要重用的语句定义一个 View ，并为其指定一个适当的名称。