您现在正在浏览：站长之家 >> 数据库 >> 详细内容

ACCESS数据库向My SQL快速迁移小程序（一）

时间:2007-12-23 来源:不详作者:迈克DB

$idcounts = odbc_num_fields( $recordsid ) ;

$fdlist1 = "" ;

for ( $i = 1 ; $i <= $idcounts ; $i )

$fdlist1 .=odbc_field_name($recordsid,$i)."," ;

echo "<div> Fd1 = " . $fdlist1 ;

$fdlist1 = substr($fdlist1,0,strlen($fdlist1)-1) ;

$fdlist2 = "" ;

$sqlquery = "select * from " . $mysql_table . " where 1=2 " ;

$records2 = mysql_query ($sqlquery) ;

$idcount2 = mysql_num_fields ( $records2 ) ;

for ( $i = 0 ; $i < $idcount2 ; $i )

$fdlist2 .= mysql_field_name($records2,$i )."," ;

echo "<div> FD2 = " . $fdlist2 ;

$fdlist2 = substr($fdlist2,0,strlen($fdlist2)-1) ;

$fp = fopen ("fdlist.txt","w") ; 织梦内容管理系统

fwrite ($fp,$ctable) ;

fwrite ($fp,"n");

fwrite ($fp,$fdlist1) ;

fwrite ($fp,"n");

fwrite ($fp,$etable) ;

fwrite ($fp,"n") ;

fwrite ($fp,$fdlist2) ;

fclose($fp) ;

odbc_close($conn);

if ( $idcount2 != $idcounts ){

echo "<hr size=1 color=#900000>".

"<div style='font-size:20pt;font-family:times;font-weight:bold'> The fields of two tables doesn't match" ;

echo "<br><br>ODBC_table Fields = " . $idcounts;

echo "<br><br>MySQL_table Fields = " . $idcount2;
}
?>

</body>
</html>

~~~~~~~~~~~~~~~~~~~
未完接(二)
~~~~~~~~~~~~~~~~~~~　　 mysql