1、SQL语句
Mysql数据库导出数据字典:
SELECT
TABLE_SCHEMA as '数据库名称',
TABLE_NAME as '表字段名',
COLUMN_NAME as '列字段名',
COLUMN_TYPE as '列字段类型',
COLUMN_KEY as '字段约束类型',
EXTRA as '字段自增',
IS_NULLABLE as '是否为空',
COLUMN_COMMENT as '字段说明'
FROM
information_schema. COLUMNS
WHERE
TABLE_SCHEMA = 'database_name';
Mysql查询某列名(column_name)所在的数据库表名(table_name)
SELECT TABLE_SCHEMA,TABLE_NAME FROM information_schema.`COLUMNS` WHERE COLUMN_NAME = 'column_name';
2、使用示例