先

SET FOREIGN_KEY_CHECKS=0;

然后delete删除，再

SET FOREIGN_KEY_CHECKS=1;