php在多个表的同一列中收集mysql结果
php在多个表的同一列中收集mysql结果
提问于 2011-06-24 01:47:49
我把我的数据库分成4个表。每一个都是相同的结构。
$sql = "SELECT * FROM `dba` WHERE domain>= (SELECT FLOOR( MAX(domain) * RAND()) FROM `dba` ) ORDER BY domain LIMIT 1";
$result = mysql_query($sql);
while($list = mysql_fetch_array($result)){
$domain = $list["domain"];
echo $domain;
}现在，来自sql_query的结果只返回一行。如何从4个表格中全部展示出来。谢谢
回答 1
Stack Overflow用户
发布于 2011-06-24 17:04:18
使用UNION
SELECT * FROM `dba` WHERE domain>= (SELECT FLOOR( MAX(domain) * RAND()) FROM `dba` ) ORDER BY domain LIMIT 1
UNION
SELECT * FROM `dbb` WHERE domain>= (SELECT FLOOR( MAX(domain) * RAND()) FROM `dbb` ) ORDER BY domain LIMIT 1
UNION
SELECT * FROM `dbc` WHERE domain>= (SELECT FLOOR( MAX(domain) * RAND()) FROM `dbc` ) ORDER BY domain LIMIT 1
UNION
SELECT * FROM `dbd` WHERE domain>= (SELECT FLOOR( MAX(domain) * RAND()) FROM `dbd` ) ORDER BY domain LIMIT 1页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/6458400
复制相关文章
相似问题
腾讯云开发者
