(select * from ORDER1 where ID=15) union (select * from ORDER2 where ID=15) union (select * from ORDER3 where ID=15)
to chinaworker(网络混混 Hrcn.CN union 应该是4。0以后的版本才支持
mysql 指令 CREATE TEMPORARY table tmp SELECT * FROM ORDER1 WHERE id=15; insert into tmp SELECT * FROM ORDER2 WHERE id=15; insert into tmp SELECT * FROM ORDER3 WHERE id=15; select * from tmp以上指令可在mysql控制台中运行,不可在phpmyadmin中执行可用php编程执行 <? $conn = mysql_connect(); mysql_select_db("test"); $ar = array( "CREATE TEMPORARY table tmp SELECT * FROM ORDER1 WHERE id=15", "insert into tmp SELECT * FROM ORDER2 WHERE id=15", "insert into tmp SELECT * FROM ORDER3 WHERE id=15", "select * from tmp" ); foreach($ar as $v) $rs = mysql_query($v);while($r = mysql_fetch_array($rs)) print_r($r); ?>
union 应该是4。0以后的版本才支持
CREATE TEMPORARY table tmp SELECT * FROM ORDER1 WHERE id=15;
insert into tmp SELECT * FROM ORDER2 WHERE id=15;
insert into tmp SELECT * FROM ORDER3 WHERE id=15;
select * from tmp以上指令可在mysql控制台中运行,不可在phpmyadmin中执行可用php编程执行
<?
$conn = mysql_connect();
mysql_select_db("test");
$ar = array(
"CREATE TEMPORARY table tmp SELECT * FROM ORDER1 WHERE id=15",
"insert into tmp SELECT * FROM ORDER2 WHERE id=15",
"insert into tmp SELECT * FROM ORDER3 WHERE id=15",
"select * from tmp"
);
foreach($ar as $v)
$rs = mysql_query($v);while($r = mysql_fetch_array($rs))
print_r($r);
?>