Gurantee Unique for a Long Text Column
You may have known that unique index on a string-typed column has limitation on prefix length, which can't guarantee that uniqueness is working properly if… Read More »Gurantee Unique for a Long Text Column
Unique Key
Unique Index Reject Distinct Row?
We all know unique constraints reject only duplicated rows from inserting into the database, but in this case, one of my unique indexes also rejects… Read More »Unique Index Reject Distinct Row?
Partition Key Makes Unique Index Useless
Normally, we build an unique index for protecting the table from inserting duplicate values of combined columns. If the constraint of the unique index is… Read More »Partition Key Makes Unique Index Useless
How to Resolve ERROR 1712 (HY000): Index table_name is corrupted
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 1712 (HY000): Index table_name is corrupted
How to Resolve ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
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 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function