How to convert a SQL select query to a formatted HTML table in MySQL functions

I'm looking for a way to generate valid HTML in MySQL (no PHP) by converting any query output to an HTML table.

Here's my progress and obviously I'm stuck. Hope I can help, thanks.

1. "dynSQL" is a procedure to accept any Select query and create a named table from it

Since MySQL does not allow dynamic queries in the functions I call a procedure that creates a named table tmp

. I cannot use a temporary table because information about temporary tables is not available in information_schema (in mysql 5.6)

CREATE DEFINER=`root`@`%` PROCEDURE `dynSQL`(SQL_QUERY TEXT)
BEGIN
set @SQLQ := 'Drop table if exists tmp;';
PREPARE stmt from @SQLQ;
Execute stmt;

SET @SQLQ := concat('create table tmp as ',SQL_QUERY);
PREPARE stmt from @SQLQ;
Execute stmt;

-- I'm adding a auto increment ID column to be able to loop through the rows later

SET @SQLQ := "ALTER TABLE tmp add column CustColHTML_ID INT NOT NULL AUTO_INCREMENT FIRST, ADD primary KEY Id(CustColHTML_ID)";
PREPARE stmt from @SQLQ;
Execute stmt;


DEALLOCATE PREPARE stmt;

END

      

        
        
        
      

    

2. "MakeHTML" - a function to read from a table tmp

and return a formatted HTML table

CREATE DEFINER=`root`@`%` FUNCTION `MakeHTML`() RETURNS text CHARSET utf8
    DETERMINISTIC
BEGIN

    DECLARE HTML text default "<TABLE><TR>";
  DECLARE rowCount int default 0;
    DECLARE i int default 0;
    select concat('<TR>',group_concat('<TD>',column_name,'</TD>' separator ''),'</TR>') into html from information_Schema.`columns` where table_name='tmp';
    Select max(CustColHTML_ID) into rowCount from `tmp`; -- Set the row counter
    WHILE i<=rowCount DO

  -- What do I do here? How do I loop through the columns of table tmp?

        set i:=i+1;
    END WHILE;
    RETURN HTML;  
END

      

        
        
        
      

    

As you can see, I am stuck on traversing unknown and dynamic table columns tmp

. I've read about how a cursor can be used here, but all the examples I've seen use known columns and assign them to specified variables. However, since the query itself is dynamic, I would not know the column names.

I am very grateful for your time and help, thank you!

ps I posted this as a new question because my previous question was marked closed as too broad. I subsequently edited my question, but it was still showing as closed. So I deleted the old question and replaced it with this one.