How to truncate table with foreign key constraint in MySQL? SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table1; Curly hair, very fair, please share :)Click to share on Twitter (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Telegram (Opens in new window)Click to share on WhatsApp (Opens in new window)Click to email a link to a friend (Opens in new window) Subash Chandran 22nd January 2022 Leave a Comment