使用mysql数据库的JdbcTemplate在Spring mvc中更新/删除？

Question

我在两个表上的Spring MVC中执行CRUD。我的两个表employeedetail [主表]和employeeid作为外键登录[子表]。当我跑步时我的查询

查询1.

DELETE e.* ,l.* FROM employeedetail e JOIN login l ON l.employeeid=e.employeeid WHERE l.employeeid=10; 

错误：

Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails (springmvcmaven . login , CONSTRAINT employee_login_id_fk FOREIGN KEY (employeeid) REFERENCES employeedetail (employeeid) ON DELETE NO ACTION ON UPDATE NO ACTION)

查询2：

DELETE e.* ,l.* FROM employeedetail e JOIN login l ON l.employeeid=e.employeeid WHERE employeeid=10; 

错误：

Error Code: 1052. Column 'employeeid' in where clause is ambiguous

可以帮助我这个。

Answer 1

解决方案1： -

外键约束，你可以声明为ON DELETE CASCADE。因此，当主表中的记录被删除时，子表中的所有记录将被自动删除。

Refer delete on cascade

解决方案2： -

删除子表中的记录，即login表第一

删除主表记录即employeedetail表

DELETE FROM login l WHERE l.employeeid=10; 
DELETE FROM employeedetail e WHERE e.employeeid=10;