使用MySQLi列出数据库中的所有表 [英] list all tables in a database with MySQLi

问题描述

我环顾四周，但仍然找不到如何列出数据库中所有表的方法. MySQLi有可能吗?

I have looked around and still can't find how to list all my tables in a database. is it possible with MySQLi?

谢谢.

推荐答案

有很多方法.

SHOW TABLES

是最简单的SQL语句.如果您想了解更多详细信息或进行过滤等操作，也可以查看INFORMATION_SCHEMA.TABLES.

Is the most simple SQL statement for doing that. You can also take a look at INFORMATION_SCHEMA.TABLES if you want to have more details or do some filtering or such.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA LIKE 'your_database';

这篇关于使用MySQLi列出数据库中的所有表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！