How can I use temp table when creating view?

MySQL 开发者_C百科doesn't allow temp table when creating a view, is there any work around for that?

Maybe you could use a permanent table with ENGINE=MEMORY as a halfway house. Just remember to truncate it when you are done working with it.