Force DROP TABLE in MySQL with foreign key constraint

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

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

 

 

Share

Microsoft Word adding an extra space before colon

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.

Share

Removing even more annoying context menus

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

Share