Bogus foreign key constraint fail

by

On demand, now as an answer…

When using MySQL Query Browser or phpMyAdmin, it appears that a new connection is opened for each query (bugs.mysql.com/bug.php?id=8280), making it neccessary to write all the drop statements in one query, eg. 

SET FOREIGN_KEY_CHECKS=0; 
DROP TABLE my_first_table_to_drop; 
DROP TABLE my_second_table_to_drop; 
SET FOREIGN_KEY_CHECKS=1;

Where the SET FOREIGN_KEY_CHECKS=1 serves as an extra security measure…

More Related Contents:

  1. MyISAM versus InnoDB [closed]
  2. MySQL foreign key constraints, cascade delete
  3. How do I see all foreign keys to a table or column?
  4. How do I quickly rename a MySQL database (change schema name)?
  5. How to debug Lock wait timeout exceeded on MySQL?
  6. MySQL AUTO_INCREMENT does not ROLLBACK
  7. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  8. Howto: Clean a mysql InnoDB storage engine?
  9. How to shrink/purge ibdata1 file in MySQL
  10. Restore table structure from frm and ibd files
  11. MySQL InnoDB not releasing disk space after deleting data rows from table
  12. What’s the difference between MyISAM and InnoDB? [duplicate]
  13. Why is MySQL InnoDB insert so slow?
  14. How to convert all tables from MyISAM into InnoDB?
  15. Prevent auto increment on MySQL duplicate insert
  16. MySQL InnoDB foreign key between different databases
  17. Force InnoDB to recheck foreign keys on a table/tables?
  18. What is MySQL’s default ON DELETE behavior?
  19. How to optimize COUNT(*) performance on InnoDB by using index
  20. How do I repair an InnoDB table?
  21. How to enable INNODB in mysql
  22. How to disable index in innodb
  23. How can I check MySQL engine type for a specific table?
  24. How do I rename a MySQL database (change schema name)?
  25. How to regex in a MySQL query
  26. Why doesn’t MySQL’s MyISAM engine support Foreign keys?
  27. Database corruption with MariaDB : Table doesn’t exist in engine
  28. Defining Composite Key with Auto Increment in MySQL
  29. MySQL DROP all tables, ignoring foreign keys
  30. How can I rebuild indexes and update stats in MySQL innoDB?

Leave a Comment