mysql - SQL-如何在一列和两个结果中获取两个不同列的值？

Question

这个标题可能很奇怪，但我正在寻找可以执行此操作的查询:

我的表格中有 1 行，如下所示:

传感器地址 |类型_测量_1 |类型_测量_2

我想做一个 SQL 查询，它可以给我这样的东西:

• result 1 : Sensor_address = X | type_measure = type_measure_1

• result 2 : Sensor_address = X (the same) | type_measure = type_measure_2

这在 SQL 中可能吗？

Answer 1

类似这样的事情:

SELECT Sensor_address, type_measure_1 as type_measure FROM [table] 
UNION ALL
SELECT Sensor_address, type_measure_2 as type_measure FROM [table]