查询数据库表结构

查询表结构：
SELECT
t.COLUMN_NAME AS 字段,
t.COLUMN_COMMENT AS 注释,
t.COLUMN_TYPE AS 类型
FROM
information_schema.`COLUMNS` t
WHERE
t.TABLE_SCHEMA = (SELECT DATABASE())
AND t.TABLE_NAME = 'store_appointment';