How to Create a Pivot Table in MySQL

[@toptechkit]

Thanks for this. It is possible to explain how we can make the years dynamic- meaning that if data for a new year is added then you donot have to come back to the query to include the new year. The years are dynamically added. Thanks.

[@DatabaseStar]

The only way that I know of would be to use "dynamic SQL", where you construct the query as a string and select the available year values to add to the query string, then run the query from the string.

[@lovetheentertainment9949]

Can you please update the database design course in udemy as same as effective database design course in your website, I will buy atleast the udemy course. This is a small request from your subscribers end.

[@DatabaseStar]

I could update the course, but why would you want it on Udemy instead of my website? The website uses Kajabi which is a leading course platform.

[@richardduncan3403]

Turns out zero is a real number ;)

[@DatabaseStar]

That's right!