SELECT GROUP_CONCAT(
  CONCAT(
    'SELECT `Province/State`, ',
    	'`Country/Region`,',
    	'`Lat`,',
    	'`Long`,''',
       COLUMN_NAME, ''' AS `Date`, ',
       '`', COLUMN_NAME, '` AS `Cases` ',
    'FROM `covid_19_confirmed_cases` '
  ) SEPARATOR ' UNION ALL '
)
into @concat_table
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'covid_19_confirmed_cases'
AND COLUMN_NAME not in ('Province/State','Country/Region','Long','Lat');