对于mysql 复制表数据可以使用 insert into select 方式
示例：
$sql="insert into icarzoo.provider(providerId,provider_name,addressid,address,phone,state,regtime,parentid,provider_type,city)
select P.id,P.providername,A.addressid,P.address,P.phone,'1','11111','0','s',A.province from icarzoo20110723_dbo.providerinfo P left join icarzoo.address A on P.cityid=A.cityid";