数据库查询字段属性

SELECT
    CONCAT(LPAD(DENSE_RANK() OVER (ORDER BY ORDINAL_POSITION), 2, '0')) AS '序号',
    COLUMN_NAME AS '列名',
    DATA_TYPE AS '数据类型',
    CHARACTER_MAXIMUM_LENGTH AS '长度',
    CASE WHEN COLUMN_KEY = 'PRI' THEN '√' ELSE '' END AS '主键',
    CASE WHEN EXTRA LIKE '%auto_increment%' THEN '√' ELSE '' END AS '自增',
    CASE WHEN IS_NULLABLE = 'NO' THEN '' ELSE '√' END AS '允许空',
    COLUMN_DEFAULT AS '默认值',
    COLUMN_COMMENT AS '列说明'
FROM
    INFORMATION_SCHEMA.COLUMNS
WHERE
    TABLE_SCHEMA = 'your_database_name' -- 将 'your_database_name' 替换为你的数据库名
    AND TABLE_NAME = 'your_table_name' -- 将 'your_table_name' 替换为你的表名
ORDER BY
    ORDINAL_POSITION;

查询出来的结果如下，导出后就可以引用到论文上了