摘要:
1. SHOW CREATE TABLE可以查看创建分区表的CREATE语句2. SHOW TABLE STATUS可以查看表是否为分区表3. 查看INFORMATION_SCHEMA.PARTITIONS表SELECT partition_name part, partition_expression expr, partition_description descr, table_rowsFROM INFORMATION_SCHEMA.partitionsWHERE TABLE_SCHEMA = schema() AND TABLE_NAME='employees';可以查 阅读全文