用php把mysql的2个表合并生成新表？

首先解决，查询数据

1

select userlist.userid,userlist.username,userinformation.address from userlist left join userinformation on userlist.userid=userinformation.userid

然后，再把查询数据，插入到新表即可

只要在上面的语句，加上插入这句sql就可以了，最终语句如下

1

insert into `user` select userlist.userid,userlist.username,userinformation.address from userlist left join userinformation on userlist.userid=userinformation.userid

$result = mysql_query($sql)

while ($row=mysql_fetch_row($result))

    {

      $data[]=$row

    }

    print_r($data)

---