mysql怎么行转列

回答: 在MySQL中，可以使用子查询或者group_concat函数来实现行转列的功能。子查询的语法如下: SELECT id, (SELECT value FROM your_table WHERE id=t.id AND status='A') AS 'statusA', (SELECT value FROM your_table WHERE id=t.id AND status='B') AS 'statusB', (SELECT value FROM your_table WHERE id=t.id AND status='C') AS 'statusC' FROM (SELECT DISTINCT id FROM your_table) AS t; [1 这样可以将变量名称作为列名，并将数据行转换为列。另外，group_concat函数也可以实现行转列的功能。例<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [mysql 行转列](https://blog.csdn.net/zhangzlyuyx/article/details/130705783)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"] - *2* [mysql中行转列](https://blog.csdn.net/yumolan4325/article/details/79191400)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"] - *3* [【精】mysql行转列的7种方法及列转行](https://blog.csdn.net/dz77dz/article/details/127611895)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"] [ .reference_list ]