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 1697 (HY000)
How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT
ERROR 1697 (HY000) Using a date or int column as a partition key is a lot easier than using a timestamp column in MySQL. Because… Read More »How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT