MySQL: truncate foreign key constrained table - Programming Tips

You are currently viewing MySQL: truncate foreign key constrained table

MySQL: truncate foreign key constrained table

Post published:April 28, 2013
Post category:MySQL
Post comments:0 Comments

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE table1;
TRUNCATE table2;
SET FOREIGN_KEY_CHECKS=1;

X (Twitter) Facebook LinkedIn Email WhatsApp Telegram

Tags: MySQL