php+mysql 创建临时数据表

<?php require_once('../public/conn.php'); ?>
<?php 
$temp_sql = "create  temporary  table tmp_query (tmp_lid int(11) NOT NULL auto_increment PRIMARY KEY,lid int(11) default NULL,sys_company varchar(20) default NULL)";  
 
$temp_query = mysql_query($temp_sql);  
$sql="insert into  tmp_query(lid,sys_company)  select lid,sys_company from bz_line";  
   mysql_query($sql);  
 
    $sql="select * from tmp_query";  
    $query1=mysql_query($sql);  
    while($rs=mysql_fetch_array($query1)){  
        echo $rs['lid']."&nbsp;&nbsp;".$rs['sys_company'].$rs['tmp_lid']."<br>";  
    }  
?>