频道导航

• ▸ PHP
• ▸ Java
• ▸ Java SE
• ▸ Python
• ▸ C#
• ▸ C&C++
• ▸ Ruby
• ▸ VB
• ▸ asp.Net
• ▸ Go
• ▸ Perl
• ▸ netty
• ▸ Django
• ▸ Delphi
• ▸ Jsp
• ▸ .NET Core
• ▸ Spring
• ▸ Flask
• ▸ Springboot
• ▸ SpringMVC
• ▸ Lua
• ▸ Laravel
• ▸ Mybatis
• ▸ Asp
• ▸ Groovy
• ▸ ThinkPHP
• ▸ Yii
• ▸ swoole
• ▸ HTML
• ▸ HTML5
• ▸ JavaScript
• ▸ CSS
• ▸ jQuery
• ▸ Bootstrap
• ▸ Angularjs
• ▸ TypeScript
• ▸ Vue
• ▸ Dojo
• ▸ Json
• ▸ Electron
• ▸ Node.js
• ▸ extjs
• ▸ Express
• ▸ XML
• ▸ ES6
• ▸ Ajax
• ▸ Flash
• ▸ Unity
• ▸ React
• ▸ Flex
• ▸ Ant Design
• ▸ Web前端
• ▸ 微信小程序
• ▸ 微信公众号
• ▸ iOS
• ▸ Android
• ▸ Swift
• ▸ Hybrid
• ▸ Cocos2d-x
• ▸ Flutter
• ▸ Xcode
• ▸ Silverlight
• ▸ cocoa
• ▸ Cordova

• 前端之家
• PHP
• mysql数据库差异比较的PHP代码

<div class="codebody" id="code58459">
<?
MysqL_connect('localhost','root','root');
MysqL_select_db('tablea'); //标准的数据库
$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[0];
}
}
MysqL_close();
MysqL_connect('localhost','root');
MysqL_select_db('tableb');//需要比较的数据库
$q2 = MysqL_query("show tables");
while($s2 = MysqL_fetch_array($q2)){
$name2= $s2[0];
$q3 = MysqL_query("desc $name2");
while ($s3 = MysqL_fetch_array($q3)) {
$aa[$name2][] =$s3[0];
}
}
MysqL_close();
$f = $e = array();
$str = $fuhao ='';
foreach($a as $k=>$v){
if(!is_array($aa[$k])){
$e[] = $k;
}
else{
if(count($aa[$k]) <> count($v)){
foreach($v as $k1=>$v1){
if(!in_array($v1,$aa[$k])){
$f[$k][] = $v1;
}
}
}
}
}
echo "

"; 
print_r($e);//缺少表 
print_r($f);//缺少表的字段 
?>