Mysql get field names from table

Stratos Provatopoulos

I am currently working as a web developer in Greece for an advertising agency but I consider myself to be an all around technology enthusiast. I like working both front end and back end, so I guess that makes me a full stack developer. You can find me at , Twitter, Linkedin and Facebook

2 Responses

  1. Firstly, thank you for such wonderful examples! Some very interesting and useful stuff to use in MySQL, which leads me to my next point.

    I’m VERY new to MySQL [less than 60 days experience], I’ve constructed many LAMP servers but am in a position now where I’ve got to actually put together the databases, frontends and backends, I’m using the Oracle Netbeans IDE 8.0.2.

    I’ve been working on a project to track attendance at the museum where I work part time. I need to generate several types of reports with pie chart data. I’ve already got the API working and queries together for a frame with with subtotals and grand total, but I have been unable to solve this problem:

    I have generated a VIEW in MySQL Workbench using the SUM command to total four columns. They are stored in the view as one row of numeric data with the grand total at the end.

    The pie chart API want the information as two columns, the NAME and the TOTAL.

    Is there a way to pivot the data and retrieve the original column names to insert into the view result?

    Any help at all would be GREATLY appreciated, let me know if you’d like to have a look at some of the view queries.

    yours truly,

    -Ed Haardt

Leave a Reply

Your email address will not be published. Required fields are marked *