desc 库名.表名; show create table 库名.表名; show partitions from 库名.表名; SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS,TABLE_COMMENT FROM information_schema.tables where TABLE_SCHEMA='库名' and TABLE_NAME='表名';