Skip to content

How to truncate table with foreign key constraint in MySQL?

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;
See also  HackerRank Solutions - Queues - A Tale of Two Stacks - Java Solution
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

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