返回MySQL中的数据库列表？
要返回数据库列表，语法如下：
select schema_name as anyAliasName from information_schema.schemata;
这是查询以返回MySQL中数据库的列表-
mysql> select schema_name as DatabaseName from information_schema.schemata;
这将产生以下输出-
+---------------------------+| DatabaseName |
+---------------------------+
| mysql |
| information_schema |
| performance_schema |
| sys |
| business |
| sample |
| hello |
| test |
| mybusiness |
| databasesample |
| schemasample |
| universitydatabase |
| education |
| mydatabase |
| database1 |
| sampledatabase |
| test3 |
| javadatabase2 |
| javasampledatabase |
| rdb |
| onetomanyrelationship |
| webtracker |
| web |
| commandline |
| hb_student_tracker |
| bothinnodbandmyisam |
| customertracker |
| tracker |
| demo |
| customer_tracker_database |
| login |
| onlinebookstore |
| customer-tracker |
| web_tracker |
| instant_app |
| 1233 |
+---------------------------+
36 rows in set (0.00 sec)
以上是 返回MySQL中的数据库列表？ 的全部内容， 来源链接： utcz.com/z/316314.html
