$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语句执行吗?
最佳答案
