mysqlすべてのテーブル構造と注釈を取得

ライブラリ名に基づいてすべてのテーブル情報をエクスポートします.

SELECT
    *
FROM
    information_schema.`TABLES`
WHERE
    TABLE_SCHEMA = 'db_name'

ライブラリ名に基づいてすべてのテーブル名とテーブルコメントをエクスポートします.

SELECT
    TABLE_NAME,
    TABLE_COMMENT
FROM
    information_schema.`TABLES`
WHERE
    TABLE_SCHEMA = 'db_name';

mysqlは、ライブラリ全体のすべてのテーブルとテーブル構造を取得します.

SELECT
    TABLE_SCHEMA AS '  ',
    TABLE_NAME AS '  ',
    COLUMN_NAME AS '  ',
    ORDINAL_POSITION AS '      ',
    COLUMN_DEFAULT AS '   ',
    IS_NULLABLE AS '    ',
    DATA_TYPE AS '    ',
    CHARACTER_MAXIMUM_LENGTH AS '      ',
    NUMERIC_PRECISION AS '    (    )',
    NUMERIC_SCALE AS '    ',
    COLUMN_TYPE AS '   ',
    COLUMN_KEY 'KEY',
    EXTRA AS '    ',
    COLUMN_COMMENT AS '  '
FROM
    information_schema.`COLUMNS`
WHERE
    TABLE_SCHEMA = 'db_name'
ORDER BY
    TABLE_NAME,
    ORDINAL_POSITION;