Lấy tên bảng bằng SELECT statement trong MySQL?

Truy vấn INFORMATION_SCHEMA.TABLES.

Cú pháp

SELECT TABLE_NAME AS TablesName
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'TenDatabaseCuaBan';

Ví dụ với database 'test'

mysql> USE test;
Database changed
mysql> SELECT TABLE_NAME AS TablesName
    -> FROM INFORMATION_SCHEMA.TABLES
    -> WHERE TABLE_SCHEMA = 'test';

+--------------------+
| TablesName         |
+--------------------+
| destination        |
| myisamtoinnodbdemo |
| originaltable      |
+--------------------+
3 rows in set (0.00 sec)