如何显示带有列的MySQL表名？
您可以使用 INFORMATION_SCHEMA.COLUMNS 表来显示带有列的 MySQL 表名。语法如下 -
SELECT DISTINCT TABLE_NAME,Column_Name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'yourDatabaseName';登录后复制
mysql> SELECT DISTINCT TABLE_NAME,Column_Name -> FROM INFORMATION_SCHEMA.COLUMNS -> WHERE TABLE_SCHEMA = 'sample';登录后复制
