truncate table with foreign key rows code example

Example: how to truncate table with foreign key constraint

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;