mysql - MySQL select 语句中的重复行

Question

我有以下查询:

SELECT word, count
FROM t_word t
JOIN t_counter tc
ON t.word_id = tc.id

这会产生类似的东西:

'cab', 2
'capital', 3
'new york', 2

我想做的是让结果显示如下:

'cab',
'cab'
'capital',
'capital',
'capital', 
'new york',
'new york'

因此计数列实际上重复了我的查询的该行。我不完全确定这是否可能，因为我没有在 MySQL 中玩过太多循环......非常感谢任何指导!。

Answer 1

Select T.word
From t_word As T
    Join    (
            Select 1 As Num
            Union All Select 2
            Union All Select 3
            ) As Numbers
        On Numbers.Num <= T.count

如果 count 实际上来自 counter 表，那么您将执行以下操作:

Select T.word
From t_word As T
    Join t_counter As TC
        On TC.id = t.word_id
    Join    (
            Select 1 As Num
            Union All Select 2
            Union All Select 3
            ) As Numbers
        On Numbers.Num <= TC.count