js mysql getting table (object) keys

[Mihajlo Spasic]

I'm interested in getting the table keys. For example, I want to get the column names when looping through a table. I thought that results[key] would provide me that but I was mistaken. I read the documentation but I didn't find what I needed, even if it is there I probably just didn't understand it.

DBconnection.query("SHOW TABLES", function (error, results, fields) {

  if (error) console.error(error);

  for (let result in results) {

    for (const key in results) {

      console.log(`${key}: ${results[key]}`);

    }

  }

  console.log(results);

});