我试图在运行时从表中获取未知列的总数。
下面是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 |
+-----------+-----------+