查看mysq表结构方案

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_%'