如何能在 MariaDB 数据库中显示数据库表:
+--------------+--------------------+----------------------------+------------------------+----------+
| CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+--------------+--------------------+----------------------------+------------------------+----------+
| def | information_schema | utf8 | utf8_general_ci | NULL |
| def | mysql | latin1 | latin1_swedish_ci | NULL |
| def | ossez_bbs | utf8 | utf8_general_ci | NULL |
| def | ossez_ucenter | utf8 | utf8_general_ci | NULL |
| def | performance_schema | utf8 | utf8_general_ci | NULL |
| def | test | latin1 | latin1_swedish_ci | NULL |
+--------------+--------------------+----------------------------+------------------------+----------+
可以使用下面的 SQL 来进行查看即可。
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;
上图显示的是执行结果。
Comments