sql查询表的详细结构

sql查询表的设计字段

SELECT
    column_name AS '字段名称',
    column_type AS '字段类型',
    column_comment AS '字段注释',
    IF(column_key='PRI','TRUE','FALSE') AS '主键唯一',
    IF(IS_NULLABLE='NO','TRUE','FALSE') AS '非空'
FROM
    information_schema. COLUMNS
WHERE
    TABLE_SCHEMA = '库名'
AND table_name = '表名';

sql查询表的主键

 SELECT `COLUMN_NAME`
        FROM `information_schema`.`COLUMNS`
        WHERE (`TABLE_SCHEMA` = #{tableSchema})
        AND (`TABLE_NAME` = #{tableName})
        AND (`COLUMN_KEY` = 'PRI');