MySQL查询表字段信息

SELECT
    column_name,
    column_comment,
    data_type
FROM
    information_schema. COLUMNS
WHERE
    table_name = 'tablename'
AND table_schema = 'database_name'