mysql查询如何竖表模表

在MySQL中，如果你想要将查询结果组织成竖表模式，即一列对应多个值，你可以使用多个`SELECT`语句拼接，或者使用`UNION ALL`将它们合并，或者使用`GROUP_CONCAT`函数。以下是一些示例：

使用多个`SELECT`语句拼接

```sql

SELECT 'Column1' AS `Column`, `Value1`, `Value2`, `Value3`

FROM `table`

UNION ALL

SELECT 'Column2', `Value1`, `Value2`, `Value3`

FROM `table`

UNION ALL

SELECT 'Column3', `Value1`, `Value2`, `Value3`

FROM `table`;

```

使用`UNION ALL`合并

```sql

SELECT 'Column1' AS `Column`, `Value1`

FROM `table`

UNION ALL

SELECT 'Column1', `Value2`

FROM `table`

UNION ALL

SELECT 'Column1', `Value3`

FROM `table`

UNION ALL

SELECT 'Column2', `Value1`

FROM `table`

UNION ALL

SELECT 'Column2', `Value2`

FROM `table`

UNION ALL

SELECT 'Column2', `Value3`

FROM `table`

UNION ALL

SELECT 'Column3', `Value1`

FROM `table`

UNION ALL

SELECT 'Column3', `Value2`

FROM `table`

UNION ALL

SELECT 'Column3', `Value3`

FROM `table`;

```

使用`GROUP_CONCAT`函数

```sql

SELECT `Column`, GROUP_CONCAT(`Value` ORDER BY `Value` SEPARATOR ', ') AS `Values`

FROM (

SELECT 'Column1' AS `Column`, `Value1` AS `Value`

FROM `table`

UNION ALL

SELECT 'Column1', `Value2`

FROM `table`

UNION ALL

SELECT 'Column1', `Value3`

FROM `table`

UNION ALL

SELECT 'Column2', `Value1`

FROM `table`

UNION ALL

SELECT 'Column2', `Value2`

FROM `table`

UNION ALL

SELECT 'Column2', `Value3`

FROM `table`

UNION ALL

SELECT 'Column3', `Value1`

FROM `table`

UNION ALL

SELECT 'Column3', `Value2`

FROM `table`

UNION ALL

SELECT 'Column3', `Value3`

FROM `table`

) AS SubQuery

GROUP BY `Column`;

```

请注意，以上示例中的`table`、`Column1`、`Column2`、`Column3`、`Value1`、`Value2`、`Value3`需要替换为实际的表名、列名和值。

在实际应用中，你需要根据具体的数据结构和需求来选择最合适的方法。