sql - reuse temporary table in mysql -

sql - reuse temporary table in mysql -

i have query this:

(select id,content,userid article type='a' limit 10) union (select c.id,c.content,c.userid comment c bring together (select id,content,userid article type='a' limit 10) on c.articleid = a.id)

how can reuse instead of requerying temporary table select id,content,userid article type='a' limit 10?

i define view statement want reuse , give appropriate name.

mysql sql