mysql - 返回重新洗牌数据，将字段值设置为新列

How could I transform this

我怎么能改变这个

 SELECT 
    FieldA
    FieldB
    FieldC
  FROM mydata
  ORDER BY FieldA;


+------------------------------------------+-------------------+-----------------+
| FieldA                                   | FieldB            | FieldC          |
+------------------------------------------+-------------------+-----------------+
| 123                                      | cca               |              23 |
| 123                                      | dde               |              12 |
| 234                                      | cca               |              44 |
| 234                                      | dde               |              32 |
| 456                                      | dde               |              11 |
| 456                                      | cca               |              45 |

+------------------------------------------+-------------------+-----------------+
 SELECT