Question

mysql分区能同时对两个字段进行分区么

Answer 1

ELECT *
FROM information_schema.PARTITIONS
WHERE TABLE_NAME='core';

sql执行的内容如下：
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PARTITION_NAME SUBPARTITION_NAME PARTITION_ORDINAL_POSITION SUBPARTITION_ORDINAL_POSITION PARTITION_METHOD SUBPARTITION_METHOD PARTITION_EXPRESSION SUBPARTITION_EXPRESSION PARTITION_DESCRIPTION TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM PARTITION_COMMENT NODEGROUP TABLESPACE_NAME
NULL test core core_20100715 NULL 1 NULL LIST NULL TO_DAYS(stamp) NULL 734333 0 0 16384 NULL 0 4194304 NULL NULL NULL NULL default NULL
NULL test core core_20100716 NULL 2 NULL LIST NULL TO_DAYS(sta