Bug #8280 "set foreign_key_checks=0" doesn't work
Submitted: 3 Feb 2005 10:02 Modified: 3 Feb 2005 13:37
Reporter: Jens Schanz Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.5 OS:Linux (SuSE 9.2)
Assigned to:

[3 Feb 2005 10:02] Jens Schanz
I want to disable foreign key references for InnoDB tables with command "set foreign_key_checks=0". Command doesn't work in Query Browser. Delete was not possible.

How to repeat:
Execute "set foreign_key_checks=0" and try to delete something from a parent table.
[3 Feb 2005 13:37] Victoria Reznichenko

Thank you for the report, but this is expected behavior.
MySQL Query Browser opens new connection each time it executes a query in the query window.
If you want to use SET FOREIGN_KEY_CHECKS, you can do it in a script.
[16 Jan 2008 11:24] marcel verbeek
This is a bit strange i think. What if you want to use an import-utility? I use Maestro myself. Now i cant import data from another database unless i drop all FK's and recreate them.