MySQL Export database table name and field information

I. Export database table information

#mysql导出库的表格信息 SELECT     A.table_schema,    a.table_name,    a.table_rows,    a.create_time,    a.table_comment  from information_schema. TABLES AWHERE    ='sqlstudy'

Second, Export database field information

# #mysql导出表格字段信息 SELECT     A.table_schema,    a.table_name,    a.column_name,    a.ordinal_position,    a.data_type,    A. Column_type,    a.column_commentfrom  information_schema. COLUMNS AWHERE a.table_schema='sqlstudy'ORDER   by a.table_schema,a.table_name,a.ordinal_position

MySQL Export database table name and field information