//遠程對比表的情況??
????
????????????//鏈接本地數(shù)據(jù)庫??
????????mysql_connect（‘127.0.0.1‘‘root‘‘root‘）;???
????????mysql_select_db（‘xin‘）;?//標準的數(shù)據(jù)庫???
????????$q?=?mysql_query（“show?tables“）;???
????????while（$s?=?mysql_fetch_array（$q））{???
????????//查詢所有表名稱
????????$name?=?$s[0];???
????????$q1?=?mysql_query（“desc?$name“）;???
????????while?（$s1?=?mysql_fetch_array（$q1））?{???
????????????$a[$name][]?=$s1;???
????????????//?$a[$name][]?=$s1[0];???
?????????????//$a[$name][]?=$s1[1];???
?????????????//?echo?‘字段：‘.$s1[0].‘
‘;
?????????????//?echo?‘類型：‘.$s1[1].‘
‘;
?????????????//?echo?‘為空：‘.$s1[2].‘
‘;
?????????????//?echo?‘默認：‘.$s1[4].‘
‘;
?????????????//?echo?‘---------------
‘;
????????????}???
????????}??????
????????mysql_close（）;????

????????//鏈接遠程數(shù)據(jù)庫??
????????mysql_connect（