When trying to update a local copy of one of my MySQL databases, I got the error
Cannot delete or update a parent row: a foreign key constraint fails
when issuing the command

DROP TABLE IF EXISTS `table_a`;

As I immediately recreate the tables with the necessary foreign key constraints, I wanted to temporarily remove the constraints. After some Googl’ing, I learned that it is as simple as

SET foreign_key_checks = 0;
DROP TABLE IF EXISTS `table_a`;
SET foreign_key_checks = 1;

When looking at my blog analytics, I noticed an intriging thing: my most read post is a very old one, one I wrote more than 8 years ago. And yet, people seem to like to info that’s on there, as I regularly get comments and thank you’s from people that were close to insanity not understanding why sometimes Microsoft Word is automatically adding an extra space before a colon.

If you have been struggling with this as well, read my post of March 2008.

Building further on my series of posts to get rid of annoying context menus, another list of things to remove:

• 3D Print with 3D Builder context
  • regedit: remove subkeys
    HKEY_CLASSES_ROOT\SystemFileAssociations\.bmp\Shell\T3DPrint
HKEY_CLASSES_ROOT\SystemFileAssociations\.jpg\Shell\T3DPrint
HKEY_CLASSES_ROOT\SystemFileAssociations\.png\Shell\T3DPrint
• Cast to Device (*)
  • Add the following String value to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Shell Extensions\Blocked:
    • Key: {7AD84985-87B4-4a16-BE58-8B72A5B390F7}
    • Value: Play to Menu
• Scan with Windows Defender
  • regsvr32 /u "C:\Program Files\Windows Defender\shellext.dll
• Burn with Nero
  • Run C:\Program Files (x86)\Common Files\Nero\NeroShellExt\x64\shellreg64uninstall.reg

(*) Only disappears after reboot