How to truncate a foreign key constrained table?

by

Yes you can:

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;
TRUNCATE table2;

SET FOREIGN_KEY_CHECKS = 1;

With these statements, you risk letting in rows into your tables that do not adhere to the FOREIGN KEY constraints.

More Related Contents:

  1. MySQL Removing Some Foreign keys
  2. How to remove constraints from my MySQL table?
  3. MySQL Error 1215: Cannot add foreign key constraint
  4. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  5. MySQL foreign key constraints, cascade delete
  6. How do I see all foreign keys to a table or column?
  7. MySQL Cannot Add Foreign Key Constraint
  8. Required to join 2 tables with their FKs in a 3rd table
  9. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  10. Basics of Foreign Keys in MySQL?
  11. How do I use on delete cascade in mysql?
  12. Add Foreign Key to existing table
  13. How to change the foreign key referential action? (behavior)
  14. How do I add a custom CHECK constraint on a MySQL table?
  15. Unique constraint that allows empty values in MySQL
  16. How to create relationships in MySQL
  17. MySQL InnoDB foreign key between different databases
  18. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  19. A constraint to prevent the insert of an empty string in MySQL
  20. Force InnoDB to recheck foreign keys on a table/tables?
  21. How to add not null constraint to existing column in MySQL
  22. Is it possible to reference one column as multiple foreign keys?
  23. How to insert values in table with foreign key using MySQL?
  24. MySQL foreign key to allow NULL?
  25. Use Composite Primary Key as Foreign Key
  26. Foreign key constraints: When to use ON UPDATE and ON DELETE
  27. MySQL and Check Constraints
  28. List of Constraints from MySQL Database
  29. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  30. MySQL Relationships

Leave a Comment