mysql - 如何做 "show tables as col"类似的东西？

Question

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t              |
| t2             |
| test           |
+----------------+
3 rows in set (0.00 sec)


mysql> show tables as c;
ERROR 1064 (42000): You have an error in your SQL syntax;

我想恢复名为 c 的列中的结果，但如您所见，这是语法错误...

有没有办法做到这一点？

Answer 1

使用信息架构:

SELECT 
 table_name AS c 
FROM 
 information_schema.tables
WHERE 
 table_schema = DATABASE()