mysql动态查询未知列,MySQL在运行时从未知列获取总查询

我试图在运行时从表中获取未知列的总数。

下面是source_table:+----+------------+-----------+-----------+-----------+-----------+-----------+

| ID | Name | Unknown 1 | Unknown 2 | Unknown 3 | Unknown 4 | Unknown 5 |

+----+------------+-----------+-----------+-----------+-----------+-----------+

| 1 | abc | 10.00 | 18.00 | 5.00 | 21.00 | 6.00 |

+----+------------+-----------+-----------+-----------+-----------+-----------+

| 2 | ghq | 22.00 | 14.00 | 12.00 | 11.00 | 23.00 |

+----+------------+-----------+-----------+-----------+-----------+-----------+

| 3 | xyz | 35.00 | 8.00 | 16.00 | 7.00 | 4.00 |

+----+------------+-----------+-----------+-----------+-----------+-----------+

下面是我试图实现的期望的result_table:+-----------+-----------+

| MyColumns | Total |

+-----------+-----------+

| Unknown 1 | 67.00 |

+-----------+-----------+

| Unknown 2 | 40.00 |

+-----------+-----------+

| Unknown 3 | 33.00 |

+-----------+-----------+

| Unknown 4 | 39.00 |

+-----------+-----------+

| Unknown 5 | 33.00 |

+-----------+-----------+

我已经找到了上面未知列(第一个字段)的查询。 但是，我很难用下面的尝试代码获取总列(第二字段):SELECT `COLUMN_NAME`

FROM `INFORMATION_SCHEMA`.`COLUMNS`

WHERE `TABLE_SCHEMA` = 'mydb'

AND `TABLE_NAME` = 'source_table'

AND `COLUMN_NAME` NOT LIKE 'ID'

AND `COLUMN_NAME` NOT LIKE 'Name';

我将感谢任何帮助在这里得到我的总列(第2字段)使用我的代码上面。

更新1:@Akina answer result_table-需要更多帮助。+-----------+-----------+

| MyColumns | Total |

+-----------+-----------+

| 10.00 | 67.00 |

+-----------+-----------+

| 18.00 | 40.00 |

+-----------+-----------+

| 5.00 | 33.00 |

+-----------+-----------+

| 21.00 | 39.00 |

+-----------+-----------+

| 6.00 | 33.00 |

+-----------+-----------+