db\_table\_create\_sql() - 两个表进行比较 ### 说明 ~~~ db_schema_compare($table1, $table2) ~~~ ### 参数 * **$table1**数组形式的表一各项参数 * **$table2**数组形式的表二各项参数 ### 示例 ~~~ $id = array('type' => 'id', 'default' => 12, 'increment' => 'AUTO_INCREMENT');$sex = array('type' => 'sex', 'default' => 1);$age = array('type' => 'age', 'default' => 0);$index = array('fields' => array('id'), 'type' => 'primary');$table1 = array('tablename' => 'zefeng', 'fields' => array($id, $sex, $age), 'indexes' => array($index), 'engine' => 'InnoDB', 'charset' => 'utf8');$id = array('type' => 'id', 'default' => 12, 'increment' => 'AUTO_INCREMENT');$name = array('type' => 'name', 'default' => 11);$ages = array('type' => 'ages', 'default' => 0);$index = array('fields' => array('name'), 'type' => 'index');$table2 = array('tablename' => 'zefeng', 'fields' => array($id, $name, $ages), 'indexes' => array($index), 'engine' => 'InnoDB', 'charset' => 'utf8');var_dump(db_schema_compare($table1, $table2));array (size=2) 'fields' => array (size=1) 'diff' => array (size=2) 0 => int 1 1 => int 2 'indexes' => array (size=1) 'diff' => array (size=1) 0 => int 0 ~~~