SELECT
TABLE_NAME AS '表名',
'' AS '列名',
'' AS '类型',
'' AS '含义'
FROM
information_schema. COLUMNS
WHERE
table_schema = '你自己的库名'
AND table_name = '具体表名'
LIMIT 1
UNION ALL
SELECT
'' AS '',
COLUMN_NAME AS '',
COLUMN_TYPE AS '',
COLUMN_COMMENT AS ''
FROM
information_schema. COLUMNS
WHERE
table_schema = '你自己的库名'
AND table_name = '具体表名';
——————————————————————————————————————————————
查看特定字样下都有哪些库
show DATABASES like 'cpu_bid_%'