How can I temporarily disable a foreign key constraint in MySQL?

by

Try DISABLE KEYS or

SET FOREIGN_KEY_CHECKS=0;

Make sure to

SET FOREIGN_KEY_CHECKS=1;

after.

More Related Contents:

  1. Problems with contenttypes when loading a fixture in Django
  2. How to use django models with foreign keys in different DBs?
  3. how to delete data from table A besides the customer service and director data in table B?
  4. Error related to only_full_group_by when executing a query in MySql
  5. SQL split values to multiple rows
  6. Get records with max value for each group of grouped SQL results
  7. How to declare a variable in MySQL?
  8. How to populate a table with a range of dates?
  9. Error Code: 2013. Lost connection to MySQL server during query
  10. SQL Performance UNION vs OR
  11. Using an Alias in SQL Calculations
  12. How do I select an entire row which has the largest ID in the table?
  13. Using SQL to determine word count stats of a text field
  14. MySQL/MariaDB – order by inside subquery
  15. How to transpose mysql table rows into columns
  16. View’s SELECT contains a subquery in the FROM clause
  17. Can MySQL replace multiple characters?
  18. MySQL incorrect key file for tmp table when making multiple joins
  19. Using ORDER BY and GROUP BY together
  20. Does the order of conditions in a WHERE clause affect MySQL performance?
  21. Difference between these two joining table approaches?
  22. Select a column with a keyword name
  23. MySQL Stored Procedures not working with SELECT (basic question)
  24. ERROR 1148: The used command is not allowed with this MySQL version
  25. MySQL export into outfile : CSV escaping chars
  26. Simple Random Samples from a MySQL Sql database
  27. Use Composite Primary Key as Foreign Key
  28. MySQL Select minimum/maximum among two (or more) given values
  29. Update multiple rows with multiple ‘where’ clauses for each individual row
  30. django cannot connect mysql in docker-compose

Leave a Comment