truncate table with references in mysql code example

Example 1: mysql how to truncate table with foreign keys

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;

SET FOREIGN_KEY_CHECKS = 1;

Example 2: truncate table mysql

TRUNCATE TABLE `fourniture`