mysql 获取一个库下的所有表名

http://dev.mysql.com/doc/refman/5.1/zh/information-schema.html

官网上的第一个例子：

mysql> SELECT table_name, table_type, engine

-> FROM information_schema.tables

-> WHERE table_schema = 'db5'

-> ORDER BY table_name DESC;

这个可以获取指定库下的所有表名  是不是很爽啊  哈哈

The following statements are equivalent:

SELECT table_name FROM INFORMATION_SCHEMA.TABLES
WHERE table_schema = 'db_name'
[AND table_name LIKE 'wild']

SHOW TABLES
FROM db_name
[LIKE 'wild']