mysql数据库表sqltable
字段id，name，sex，email
access数据库表accesstable
id，name，sex，email
$connect = mysql_connect(localhost,,);
mysql_select_db(mydatabase);
$sql = select * from sqltable;
$result = mysql_query($sql};
$connectodbc=odbc_connect(dsn,username,password);
while($row = mysql_fetch_row($result))
{
$sql=insert into accesstable
values($row[id,$row[name,$row[sex],$row[email]);
odbc_do($connectodbc,$sql);
}
odbc_close($connectodbc);
mysql_close($conect);
?>
【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】