mysql 多表关联删除

sql文件：

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for stu_tea
-- ----------------------------
DROP TABLE IF EXISTS `stu_tea`;
CREATE TABLE `stu_tea` (
  `stu_id` int(11) NOT NULL,
  `tea_id` int(11) NOT NULL,
  PRIMARY KEY (`stu_id`,`tea_id`),
  KEY `stu_tea_ibfk_2` (`tea_id`),
  CONSTRAINT `stu_tea_ibfk_2` FOREIGN KEY (`tea_id`) REFERENCES `teacher` (`id`),
  CONSTRAINT `stu_tea_ibfk_1` FOREIGN KEY (`stu_id`) REFERENCES `student` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of stu_tea
-- ----------------------------
INSERT INTO `stu_tea` VALUES ('4', '2');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('4', '申达股份');
INSERT INTO `student` VALUES ('6', '的方式到');

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('1', '张老师');
INSERT INTO `teacher` VALUES ('2', '李老师');

student和stu_tea两张表内关联删除：

DELETE st,s
FROM
    student s
inner JOIN stu_tea st ON s.id = st.stu_id

分析：
删除顺序：根据内关联的前后顺序进行删除，上述sql语句先删除表student ，后删除表stu_tea，不是按照st,s 这个抒写顺序删除的

---

student和stu_tea两张表外关联删除：

DELETE s,st

FROM
    stu_tea st
left JOIN student s ON s.id = st.stu_id

分析：
删除顺序：根据外关联的前后顺序进行删除，左关联先删除左边的关联表，右关联先删除右边的表，上述sql语句左关联先删除表stu_tea，后删除表student；

删除顺序对于外键约束RESTRICT、NO ACTION，删除顺序不对可能导致sql无法执行；