How to store MySQL query results in another Table?

If the table doesn’t exist (and you e.g. don’t want to create it because it may have lots of column names) you can create it on the fly…

Query:

CREATE TABLE another_table SELECT /* your query goes here */