我试图创建一个查询,从同一个表中选择多行,将它们像数组一样分组。现在我使用php来选择它们,如下所示:
$tks = mysqli_query($con,"SELECT * FROM hof ORDER BY tks DESC LIMIT 5");
$top_ths = mysqli_query($con,"SELECT * FROM hof ORDER BY ths DESC LIMIT 1");
$top_tha = mysqli_query($con,"SELECT * FROM hof ORDER BY tha DESC LIMIT 1");
----
我想把它们合并到一个查询中,这样我就得到了一个关联数组。类似这样的东西:
(SELECT * FROM hol ORDER BY tks DESC LIMIT 5) AS tks
UNION
(SELECT * FROM hol ORDER BY ths DESC LIMIT 1) AS top_ths
所以tks包含所有5行,top_ths包含1行。有可能吗?谢谢
从组行的下方开始,使附加字段
(SELECT *, 1 as `group` FROM hol ORDER BY tks DESC LIMIT 5)
UNION
(SELECT *, 2 as `group` FROM hol ORDER BY ths DESC LIMIT 1)