Shulou(Shulou.com)06/01 Report--

How does mysql change the vertical to horizontal arrangement? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The first step is to create the data table, which I have created here. The following is the data diagram shown.

The second step is to display the total score of each class vertically, using the following sentence:

Select class,sum (score) from student group by class

Query results:

In the third step, to display the result horizontally, use the case when statement as follows:

The scores of select sum (case when class=' 'then score else 0 end), sum (case when class='' then score else 0 end) and sum (case when class=' 'then score else 0 end) are one year, one year and three classes a year, respectively.

Query results:

Thank you for reading! After reading the above, do you have a general idea of how to change the vertical and horizontal arrangement of mysql? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.