SHOW TABLES; -- 查看表 SHOW TABLES FROM test11; SELECT TABLE_NAME FROM information_schema.TABLES; SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA='discuz'; SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='discuz'; SELECT * FROM information_schema.TABLES; SELECT * FROM information_schema.TABLES WHERE TABLE_SCHEMA='test'; SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA='test11';
-
« 上一篇:
MySQL-数据库创建、删除、使用
-
MySQL-查看列字段
:下一篇 »