ÈçºÎÓÃPHP¿çÊý¾Ý¿âµ¼ÈëÊý¾Ý

±ÈÈçÎÒÓÐÁ½¸öÊý¾Ý¿âA£¬B
Êý¾Ý¿âBÏÂÓиö±íb²åµ½Êý¾Ý¿âAϵıía
±íb½á¹¹Îª
CREATE TABLE IF NOT EXISTS `b` (
  `cid` int(11) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL,
  `Upassword` varchar(255) NOT NULL,
  `area` varchar(25) NOT NULL,
  `cost` int(255) NOT NULL,
  PRIMARY KEY  (`cid`)
)
ÈçºÎÓÃPHPʵÏÖÏÂÃæÕâ¾ä
$sql="insert into a(cid,username,Upassword,area)
      select t1.cid,t1.username,t1.Upassword,t1.area from B.b t1";

ÏÂÃæÊÇÎÒ×Ô¼ºÐ´µÄÒ»¶ÎPHP
<?php
$host="localhost";
$user="root";
$password="123456";
$database_1="a";
$database_2="b";

session_start();

$link=mysql_connect($host,$user,$password) or die("fail");
mysql_select_db($database_2,$link);
$sql="select cid,username,Upassword,area from b";
$result=mysql_query($sql);
while (list($cid->cid,$username->username,$Upassword->Upassword,$area->area)=mysql_fetch_array($result)){
echo $cid->cid.' '.$username->username.' '.$Upassword->Upassword.' '.$area->area.' <br>';
    }


$link_2=mysql_connect($host,$user,$password) or die("fail");