truncate table force on foreign key code example

Example: how to truncate table with foreign key constraint

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE table1;