Field Export:

SELECTTABLE_SCHEMA AS `database name`,TABLE_NAME AS `table name`,COLUMN_NAME AS `column name`,COLUMN_TYPE AS `type`,COLUMN_DEFAULT AS `default`,IS_NULLABLE AS `Allow null`,DATA_TYPE AS `Data type`,CHARACTER_MAXIMUM_LENGTH AS `Maximum length of characters`,NUMERIC_PRECISION AS `Numeric precision`,NUMERIC_SCALE AS `Number of decimal places`,COLUMN_COMMENT AS `Field description`FROMinformation_schema.COLUMNSWHERETABLE_SCHEMA = 'db_name' #db_name represents the database name

Table export

SELECTTABLE_SCHEMA AS `database name`,TABLE_NAME AS `table name`,CREATE_TIME AS `create time`,TABLE_COLLATION AS `Character Set`,TABLE_COMMENT AS `Table comments`FROMinformation_schema.TABLESWHERETABLE_SCHEMA = 'db_name'

View export

SELECTTABLE_SCHEMA AS `database name`,TABLE_NAME AS `view name`FROMinformation_schema.VIEWSWHERETABLE_SCHEMA = 'db_name'