Mysql - Create temporary table according to dynamic SELECT

Question

Is there any way to create a temporary table according to a select with columns created dynamically, as shown in the examples below?

ex:

SELECT idCentroCusto, 'Dez/14', 'Jan/15', 'Fev/15', 'Mar/15', totalAnual

or

SELECT idCentroCusto, 'Dez/14', 'Jan/15', 'Fev/15', 'Mar/15', 'Abr/15', 'Mai/15', totalAnual

Since (as shown above) these Months/Year are dynamically created, according to the calendar parameter.

Answer 1

See the documentation of CREATE TABLE, can be created through a consultation:

CREATE TEMPORARY TABLE tabela_temporaria SELECT idCentroCusto, 'Dez/14', 'Jan/15', 'Fev/15', 'Mar/15', totalAnual;

Answer 2

Try using the Mysql "CREATE TABLE AS" command

 CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS (SELECT idCentroCusto, 'Dez/14', 'Jan/15', 'Fev/15', 'Mar/15', 'Abr/15', 'Mai/15', totalAnual FROM table1)

Source: https://stackoverflow.com/questions/5859391/create-a-temporary-table-in-a-select-statement-without-a-separate-create-table