Primary Key

How to Resolve ERROR 1712 (HY000): Index table_name is corrupted

November 20, 2015December 16, 2022

ERROR 1712 (HY000) Got this error when using mysqldump for backing up a database. At this moment, we can't do any operations but DDL. mysqldump:… 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 »