在Mysql中查询表信息SQL语句如下:
SELECT
COLUMN_name AS '列名称',
COLUMN_type AS '数据类型',
DATA_TYPE AS '字段类型',
CHARACTER_maximum_LENGTH AS '长度',
IS_NULLABLE AS '是否为空',
COLUMN_DEFAULT AS '默认值',
COLUMN_COMMENT AS '注释'
FROM
information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'db_name' -- 数据库名称
AND TABLE_NAME = 'table_name' -- 表名称
查询出结果后,就可以任意导出为想要的格式。