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';