SELECT
a.TABLE_NAME,
b.TABLE_COMMENT,
a.COLUMN_NAME,
a.COLUMN_TYPE,
a.COLUMN_COMMENT
FROM
information_schema.`COLUMNS` a
JOIN information_schema.`TABLES` b ON a.TABLE_SCHEMA = b.TABLE_SCHEMA
AND a.TABLE_NAME = b.TABLE_NAME
WHERE
a.TABLE_NAME = 'goods'
