I upgraded from MySQL 5.1 to 5.6.17. Now in Wordpress plugins some of my timestamp columns have started behaving strangely.
MySQL documentation on this very critical feature enhancement (decimals in timestamp fields) is sloppy. SO one relies on blogs/websites.
Some websites such as this recommend
But this did nothing for the older data. Some tables which rely on the uniqueness of the timestamp field, now have ".0000" in the 4 digit suffix. Even the
ALTER TABLE FORCE didn't change that data.
Any ideas on what we can do instead of manually tinkering with the timestamp fields? Thanks!