我尝试从tbl_user中删除单行,从user_subscription_log中删除多行,我的连接查询是:
DELETE tbl_user, user_subscription_log
FROM tbl_user
INNER JOIN user_subscription_log ON tbl_user.id = user_subscription_log.user_id
WHERE tbl_user.id='256'返回的错误为:
#1451 -无法删除或更新父行:外键约束失败(databasename。user_subscription_log,constraint foreirgn_key_user_id外键(user_id)引用tbl_user (id))
发布于 2016-07-25 06:05:04
它失败,因为user_subscription_log表中存在一个子记录,并且没有在外键中设置'on delete‘子句。
我会执行两个delete查询:
DELETE FROM user_subscription_log WHERE user_id = ?;
DELETE FROM tbl_user where id = ?;另一个选项是在外键定义中设置'on delete cascade‘子句,如here所述。
https://stackoverflow.com/questions/38557265
复制相似问题