摘要:
classTable:id,name;studentTable:id,name;class_studentTable:class_id,student_id;变态一点的例子,想删除名称包含"2b"班级中的所有学生delete s from studentTable as sleft outer join class_studentTable on student_id = s.idleft outer join classTable on class_id = classTable.idwhere classTable.name like "%2b%" 阅读全文