P
P
Paka2020-02-07 14:02:38
MySQL
Paka, 2020-02-07 14:02:38

How to make mysql partition by varchar field?

There is a large table (1M records) with fields

good (
   id INT,
   category INT,
   company VARCHAR(15)
)


Is it possible to create table partitions by the field `good`.`company` ? Or partitions work only for numeric fields?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question