php - 将一列拆分为 3 并计算每一行

Question

我有一个普通的表:

id |value
12 |1
24 |3
35 |20

..等等 id 让我们说 100。我想知道是否有一个查询来选择所有，但是将该列拆分为 3 个等距的列并从 1 到 33、第二个 34-66、67- 100(或任何接近该逻辑的值)

预期输出:我不关心 id，所以需要的是

order1|value1  order2|value2 order3|value3
    1 |1           34|80          67|206
    2 |4           35|100         68|207
    3 |6           36|102         69|280
    ...            ....            ...
    33|60          66|201        100|810

Answer 1

我想这就是您要找的:

SELECT *
FROM (
      SELECT (@var_count := @var_count + 1) AS order1, value AS value1, 0 order2, 0 value2, 0 order3, 0 value3
      FROM table_name, (SELECT @var_count := 0) a
      LIMIT 33

      UNION ALL

      SELECT 0 order1, 0 value1, (@var_count := @var_count + 1) AS order2, value AS value2, 0 order3, 0 value3
      FROM table_name, (SELECT @var_count := 33) a
      LIMIT 34, 33

      UNION ALL

      SELECT 0 order1, 0 value1, 0 order2, 0 value2, (@var_count := @var_count + 1) AS order3, value AS value3
      FROM table_name, (SELECT @var_count := 66) a
      LIMIT 67, 33
     )a;