I have a table having id as primary key and date column.
I want to partition the data.. I felt month would be the best option so that I have 12 partitions.. How do I achieve that !
I am using mysql 5.6 on AWS RDS.
alter table report.track_pdp_visit partition by hash(start_date);
It gives me following error:
Field 'start_date' is of a not allowed type for this type of partitioning