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:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.5 OS:Linux (SuSE 9.2)
Assigned to: CPU Architecture:Any

[3 Feb 2005 10:02] Jens Schanz 
Description:
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] MySQL Verification Team 
Hi,

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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.037 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.