MySQL Partition by String Column
You might have known that LIST, RANGE, and HASH partitions all refuse to accept VARACHAR column as the native partition key. mysql> alter table locations… Read More »MySQL Partition by String Column
ERROR 1564 (HY000)
How to Resolve ERROR 1564 (HY000): This partition function is not allowed
ERROR 1564 (HY000) When we used round() function for the partition key, we got ERROR 1564 (HY000). mysql> alter table sales partition by range(unix_timestamp(order_time)) partitions… Read More »How to Resolve ERROR 1564 (HY000): This partition function is not allowed