php - mySQL 删除时出现意外标记

Question

我在 PHP myadmin(存储引擎 InnoDB)中有多个删除查询的问题。这是我的数据库:

这是我的查询:

DELETE placement, employees
FROM placement, employees
WHERE placement.id_emp = employees.id_emp
AND employees.id_emp = 113;

错误:

在分析过程中发现了 3 个错误。

Unexpected token. (near "placement" at position 7) Unexpected token. (near "," at position 16) Unexpected token. (near "employees" at position 18)

1451 - Cannot delete or update a parent row: a foreign key constraint fails (employment.placement, CONSTRAINT placement_ibfk_1 FOREIGN KEY (id_emp) REFERENCES employees (id_emp))

我根据本教程编写了该查询:http://www.mysqltutorial.org/mysql-delete-statement.aspx

谁能帮帮我？

Answer 1

如果您使用 "DELETE FROM placement, employees USING placement, employees WHERE ..." 会怎么样？