navicat 查询表结构导出
SELECT
TABLE_NAME 表名,
COLUMN_NAME 字段名称,
COLUMN_TYPE 字段类型,
IF
( IS_NULLABLE = 'YES', '是', '否' ) 是否可为空,
IF
( COLUMN_KEY = 'PRI', '是', '否' ) 是否主键,
COLUMN_DEFAULT 默认值,
COLUMN_COMMENT 字段注释
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'blms-jn'
SELECT
TABLE_NAME 表名,
TABLE_COMMENT 表注释
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_SCHEMA = 'blms-jn'
and table_name like '%%'