摘要: 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';可以查 阅读全文
posted @ 2012-09-17 09:21 ForA 阅读(139) 评论(0) 推荐(0) 编辑