Truncate a table with Foreign Key Constraints (If the SET FOREIGN KEY =0 doesnt work then)

Truncate Table with Foreign Key Constraints

Classic method: Turn off the Foreign Keys and 
#SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS; 
#SET FOREIGN_KEY_CHECKS=0; 

DO YOUR CHANGES!!

#SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;






If Not:

Alternative:
SET SQL_SAFE_UPDATES = 0;
DELETE FROM WFM_SkillLevelDesignationMapper;
ALTER TABLE WFM_SkillLevelDesignationMapper AUTO_INCREMENT = 1;