diff options
Diffstat (limited to 'drivers/adodb-mysqli.inc.php')
| -rw-r--r-- | drivers/adodb-mysqli.inc.php | 26 |
1 files changed, 4 insertions, 22 deletions
diff --git a/drivers/adodb-mysqli.inc.php b/drivers/adodb-mysqli.inc.php index c40e49ae..a79467a3 100644 --- a/drivers/adodb-mysqli.inc.php +++ b/drivers/adodb-mysqli.inc.php @@ -44,7 +44,10 @@ class ADODB_mysqli extends ADOConnection { var $dataProvider = 'mysql'; var $hasInsertID = true; var $hasAffectedRows = true; - var $metaTablesSQL = "SELECT + var $metaDatabasesSQL = "SHOW DATABASES + WHERE `database` NOT IN ('mysql', 'information_schema', 'performance_schema')"; + var $metaTablesSQL = /** @lang text */ + "SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES @@ -631,27 +634,6 @@ class ADODB_mysqli extends ADOConnection { } /** - * Return a list of all visible databases except the 'mysql' database. - * - * @return array|false An array of database names, or false if the query failed. - */ - function MetaDatabases() - { - $query = "SHOW DATABASES"; - $ret = $this->execute($query); - if ($ret && is_object($ret)){ - $arr = array(); - while (!$ret->EOF){ - $db = $ret->fields('Database'); - if ($db != 'mysql') $arr[] = $db; - $ret->moveNext(); - } - return $arr; - } - return $ret; - } - - /** * Get a list of indexes on the specified table. * * @param string $table The name of the table to get indexes for. |