-- create 끝에
-- hash 기반
ENGINE=InnoDB PARTITION BY HASH(account_id) PARTITIONS 16
-- list 기반
ENGINE=InnoDB PARTITION BY COLUMNS(code) (
PARTITIONS a VALUES IN ('KOSPI'),
PARTITIONS b VALUES IN ('KODAQ')
);
-- create 끝에
-- hash 기반
ENGINE=InnoDB PARTITION BY HASH(account_id) PARTITIONS 16
-- list 기반
ENGINE=InnoDB PARTITION BY COLUMNS(code) (
PARTITIONS a VALUES IN ('KOSPI'),
PARTITIONS b VALUES IN ('KODAQ')
);