mysqlデータベースフィールド&テーブル名コメントクエリー

610 ワード

SELECT
    TABLE_NAME "  ",
    COLUMN_NAME "    ",
    COLUMN_TYPE "      ",
IF
    ( EXTRA = "auto_increment", CONCAT( COLUMN_KEY, "(", IF ( EXTRA = "auto_increment", "   ", EXTRA ), ")" ), COLUMN_KEY ) "   ",
    IS_NULLABLE "   ",
    COLUMN_COMMENT "    " 
FROM
    information_schema.COLUMNS 
WHERE
    TABLE_SCHEMA = 'gzh-test-sn';
SELECT
    TABLE_NAME "  ",
    TABLE_COMMENT "  " 
FROM
    information_schema.TABLES 
WHERE
    TABLE_SCHEMA = 'gzh-test-sn';