Skip to content

How to truncate table with foreign key constraint in MySQL?

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;
See also  Airflow commands cheat-sheet
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.