Re: Partitioning by date, and maintaining uniqueness

[Rick James]

> INSERT INTO TableName (id, created) VALUES (1000,'2013-08-14 17:30:00');

Since id is AUTO_INCREMENT, do not do it that way. Instead do either of these:
INSERT INTO TableName (id, created) VALUES (NULL,'2013-08-14 17:30:00');
INSERT INTO TableName (created) VALUES ('2013-08-14 17:30:00');
Either will create the 'next' id, and you will have no dups, regardless of the indexes you have.

> this is purely theoretical as there is no reason for anyone to manually insert an id, but mistakes do happen!!

True. This is one mistake that MySQL, with PARTITIONs, will not catch. I consider it only a minor drawback of PARTITIONs.