CODE EXAMPLE FOR SQL

mysql how to truncate table with foreign keys

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;

SET FOREIGN_KEY_CHECKS = 1;