VALUES LESS THAN

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 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

July 28, 2013December 8, 2022

ERROR 1503 (HY000) Tried to partition a table, but it failed with ERROR 1503 (HY000). Primary Key mysql> ALTER TABLE orders PARTITION BY RANGE(unix_timestamp(order_time)) (PARTITION… 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 »

JavaScript is not enabled.