MySQL Partition by String ColumnNovember 15, 2015December 15, 2022You 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
How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INTSeptember 3, 2013December 8, 20222 CommentsERROR 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