mysql表分区列_如何基于char列对MySQL表进行分区？

MySQL 5.1中的分区只能处理整数列(

Source).您只能在非整数列上使用

few partitioning functions.例如：

CREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE)

ENGINE=INNODB

PARTITION BY HASH( MONTH(tr_date) )

PARTITIONS 6;

您也可以在MySQL 5.1中使用key partitioning,只要主键包含表的分区功能中的所有列：

CREATE TABLE k1 (

id CHAR(3) NOT NULL PRIMARY KEY,

value int

)

PARTITION BY KEY(id)

PARTITIONS 10;

列表列示例：

CREATE TABLE expenses (

expense_date DATE NOT NULL,

category VARCHAR(30),

amount DECIMAL (10,3)

);

ALTER TABLE expenses

PARTITION BY LIST COLUMNS (category)

(

PARTITION p01 VALUES IN ('lodging', 'food'),

PARTITION p02 VALUES IN ('flights', 'ground transportation'),

PARTITION p03 VALUES IN ('leisure', 'customer ent