mysql数据库对比表和字段是否一致_mysql 同一个表数据 同字段比较

```php
public function DBCompare()
    {
        //原数据库 连接
        //Db::connect('mysql://root:1234@127.0.0.1:3306/thinkphp#utf8')
        $Db1 = Db::connect('');
        //被检查数据库 连接
        $Db2 = Db::connect('');

        //数据库名称
        $dataBaseName1 = '';
        $ret1 = $Db1->query("SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = ?",[$dataBaseName1]);
        //被检查数据库名称
        $dataBaseName2 = '';
        $ret2 = $Db2->query("SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA = ?",[$dataBaseName2]);

        $dataTable1 = [];
        $dataTable2 = [];
        for ($i = 0; $i < count($ret1); $i++) {
            $dataTable1[$i] = $ret1[$i]['TABLE_NAME'];
        }
        for ($i = 0; $i < count($ret2); $i++) {
            $dataTable2[$i] = $ret2[$i]['TABLE_NAME'];
        }
        $ret = array_diff($dataTable1, $dataTable2);
        if (count($ret) != 0){
            var_dump("两个数据库之间的表差异,请先处理表");
            dump($ret);
            return;
        }


        for ($i = 0; $i < count($dataTable1); $i++){
            $result1 = $Db1->query("SHOW COLUMNS FROM ".$dataTable1[$i]);
            $result2 = $Db2->query("SHOW COLUMNS FROM ".$dataTable1[$i]);
            $dataTable1diff = [];
            $dataTable2diff = [];
            for ($j = 0; $j < count($result1); $j++) {
                $dataTable1diff[$j] = $result1[$j]['Field'];
            }
            for ($j = 0; $j < count($result2); $j++) {
                $dataTable2diff[$j] = $result2[$j]['Field'];
            }
            $ret = array_diff($dataTable1diff, $dataTable2diff);
            if (count($ret) != 0){
                dump("两个数据库".$dataTable1[$i].",请处理");
                dump($ret);
            }
        }

        dump("如果上面没有信息就表示两个数据库相同没有差异");
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

1