In some settings MySQL / MariaDB treats empty or null ‘datetime’ and ‘timestamp’ fields/columns as simply null, in others it writes out zeros (0s) like 0000-00-00 00:00:00. If you designed your own database, you probably know what you’re dealing with, already. But if you are working on someone else’s database, like migrating data to or from, or just doing development for it, for example, you may encounter the error “Incorrect datetime value: ‘0000-00-00 00:00:00’ for …
In version 5.6 of MySQL, you might get errors regarding InnoDB tables mysql/slave_master_info,mysql/slave_worker_info, and mysql/slave_relay_log_info like the following when the server was not gracefully shut down, and the InnoDB tables in question become eventually corrupt. This article will present detailed instructions to fix the problem.
MySQL Management and Administration with Navicat I was pleased to announce my book’s give-away campaign with Packt Publishing back on November 30th, 2012. All we asked the website visitors to do was just comment about the book below this post, and win a free e-copy of MySQL Management and Administration with Navicat. Three lucky winners got the chance to win free copies of the e-book. You could have been one of the Lucky Ones if you visited this …