ROUND

How to Resolve ERROR 1697 (HY000): VALUES value for partition must have type INT

September 3, 2013December 8, 2022
2 Comments

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 1564 (HY000): This partition function is not allowed

September 2, 2013December 30, 2022

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 »

JavaScript is not enabled.