mysql truncate ignore foreign key constraints code example

Example: mysql how to truncate table with foreign keys

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;

SET FOREIGN_KEY_CHECKS = 1;