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 Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:6.3.10 OS:Any
Assigned to: CPU Architecture:Any

[2 Sep 2015 14:34] Nahuel Sotelo
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!