Just a simple flow if you want to export MySQL table to HTML table:
[{"id":"93c06615.8f7438","type":"http in","z":"b95f374a.161db8","name":"","url":"/sqltabletohtmltable","method":"get","upload":false,"swaggerDoc":"","x":270,"y":3260,"wires":[["54a4beb6.4f344"]]},{"id":"54a4beb6.4f344","type":"change","z":"b95f374a.161db8","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"select * from test.temp","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":490,"y":3260,"wires":[["d024a2dc.3cdbf"]]},{"id":"d024a2dc.3cdbf","type":"mysql","z":"b95f374a.161db8","mydb":"f2524bf.ab510b8","name":"MySQL","x":640,"y":3260,"wires":[["360efef8.df5d92"]]},{"id":"360efef8.df5d92","type":"function","z":"b95f374a.161db8","name":"","func":"eleje=\"<!DOCTYPE html><html><head><style>\\n\" +\t \n\"table {border-collapse: collapse;width: auto; background-color:white;font-family:Tahoma;} \" +\t\n\"th, td {padding: 8px;text-align: center;border-bottom: 1px solid #ddd;} \" +\t\n\"th {background-color:dodgerblue; color:white;} \" +\t\n\"h1 {font-family:Tahoma;} \" +\t\n\"p {font-family:Tahoma;} \" +\t\n\"tr:hover {background-color: orange;} \" +\n\"</style></head>\"\n\nth=\"<tr> <th>\" + Object.keys(msg.payload[0]).join(\"</th> <th>\") + \"</th> </tr>\";\n\ntd=\"\"\nfor (i = 1; i <= msg.payload.length; i=i+1) \n{td+=\"<tr> <td>\" + Object.values(msg.payload[i-1]).join(\"</td> <td>\") + \"</td> </tr>\\n\"}\n\nmsg.payload=eleje + \"<table>\" + th + td + \"<style>tr:nth-of-type(even) {background-color:aliceblue;}</style></table></html>\"\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":780,"y":3260,"wires":[["5051a18f.5b3bc"]]},{"id":"5051a18f.5b3bc","type":"http response","z":"b95f374a.161db8","name":"","statusCode":"","headers":{},"x":910,"y":3260,"wires":[]},{"id":"f2524bf.ab510b8","type":"MySQLdatabase","name":"UPDATENAME","host":"UPDATEHOST","port":"3306","db":"UPDATEDB","tz":"","charset":"UTF8"}]
