php - 使用外键从多个表中删除不起作用

Question

我想根据学生ID删除学生记录。这是student_tbl 中的主键和所有其他表中的外键。但我没有通过；我收到此错误:

#1109 - Unknown table 'student_tbl' in MULTI DELETE

DELETE FROM `student_tbl`,`father`,`sponsor`, `postal`, `report` USING `student_tbl` std 
  INNER JOIN `father` INNER JOIN `sponsor` INNER JOIN `postal` INNER JOIN `report` 
  WHERE std.s_id = 1 AND father.s_id = std.s_id AND sponsor.s_id = std.s_id
  AND postal.s_id = std.s_id AND report.s_id = std.s_id

Answer 1

我通过更改表 student_tbl 名称及其别名解决了这个问题。