mysql删除别名错误

最新推荐文章于 2022-09-30 22:15:59 发布

weixin_30733003

最新推荐文章于 2022-09-30 22:15:59 发布

阅读量98

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/haiwei_sun/articles/2602561.html

版权

这样删除报错误

$elementSql = "DELETE FROM " . $CFG['tb_pre'] . "elements e," . $CFG['tb_pre'] . "decompose d WHERE d.project_id=" . $projectid . " AND d.id=e.decompose_id";

修改如下：

$elementSql = "DELETE e.* FROM " . $CFG['tb_pre'] . "elements e," . $CFG['tb_pre'] . "decompose d WHERE d.project_id=" . $projectid . " AND d.id=e.decompose_id";

转载于:https://www.cnblogs.com/haiwei_sun/articles/2602561.html