UNIX_TIMESTAMP

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 1486 (HY000): Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed

July 27, 2013December 8, 2022

ERROR 1486 (HY000) When we partitioned a table by a timestamp-typed column ORDER_TIME in table ORDERS, it generated an error 1486 like this: mysql> ALTER… Read More »