delete 关联条件删除数据集 如何选择表

浏览:827 发布日期:2020/06/30 分类:求助交流 关键字: SQL语句 delete关联删除
有一个关联删除需求:
$result = CusServiceModel::alias('cus')->JOIN('cus_website cusweb','cus.pid = cusweb.id')->where($where)->delete();

生成的如下语句,会提示失败,无法执行成功:
DELETE FROM cus_service cus INNER JOIN cus_website cusweb ON cus.pid=cusweb.id WHERE cus.id = 10 AND cusweb.admin_id = 2

需要在 DELETE后面跟上 cus_service 的别名 cus 即:
DELETE cus FROM cus_service cus INNER JOIN cus_website cusweb ON cus.pid=cusweb.id WHERE cus.id = 10 AND cusweb.admin_id = 2

请问最上面的模型删除语句应该如何修改才能delete 后面指定表名,,一定要用原生SQL语句执行吗?
最佳答案
评论( 相关
后面还有条评论,点击查看>>