mysql萬(wàn)級(jí)查詢,如何在MYSQL中查看所有的表名?
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '數(shù)據(jù)庫(kù)名'執(zhí)行這條語(yǔ)句就能查出庫(kù)中所有表名
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '數(shù)據(jù)庫(kù)名'執(zhí)行這條語(yǔ)句就能查出庫(kù)中所有表名