Bug #78307 Option for execute query with foreign_key_checks disabled

• Submitted: 2 Sep 2015 14:34
• Modified: 5 Feb 2018 6:42
• Reporter: Nahuel Sotelo
• Status: Verified
• Category: MySQL Workbench: SQL Editor
• Severity: S4 (Feature request)
• Version: 6.3.10
• OS: Any
• CPU Architecture: Any

[2 Sep 2015 14:34] Nahuel Sotelo

Description:
Sometimes I need to perform actions in my test database with garbage data that needs to avoid the foreign_key_checks. Or maybe when I need to do some TRUNCATE tables with FKs.

It would be nice if when showing the modal with the SQL to be executed, it would be an option to execute that script with FK checks disabled.

How to repeat:
Nothing to do here

Suggested fix:
The final execution would be:

SET foreign_key_checks = 0;

-- SQL to be executed

SET foreign_key_checks = 1;

[5 Feb 2018 6:42] MySQL Verification Team

Hello Nahuel Sotelo,

Thank you for the feature request!

Thanks,
Umesh