mysql 二次查询并合并结果集

[meinjoy]

第一个表 class 中随机获取 5 组数据 SELECT name,age FROM class , (SELECT ((1/COUNT(*))*100) as n FROM class) as x WHERE RAND()<=x.n ORDER BY RAND() LIMIT 5;

| name | age |

然后再用 class 表中的值 name 从第二表 score 中查询结果 select * from score where name=name

math | eng|

有没有办法合并成一句 sql 语句并把结果合并成

| name | age | math | eng|

[BacGa]

用 name 连表查询就行

[TimFire]

现在那么多孩子叫 zixuan 的，重名不考虑的啊？

[b821025551b]

你这玩意，重名了咋办

[wangyzj]

为啥不 join

[zclHIT]

Select c.name, c.age, s.math, s.eng, (select ((1/COUNT(*))*100) as n) as x from class c inner join score on c.name = s.name where rand()<=x.n order by rand() lmiit 5;
1. 名字不会重复吗？
2.这个随机的逻辑有点复杂吧

[BacGa]

用唯一 id 喽 class 里为了区分重名肯定存了 id