update里嵌套select 发表于 2023-05-18 更新于 2023-08-14 12345678UPDATE ht_task SET submitStatus = -1 WHERE id = ( SELECT taskId FROM ( SELECT taskId FROM ( SELECT taskId FROM ht_task_user_detail WHERE id=29 ) tb, ht_task WHERE taskId=id ) tb2 ) update里嵌套select的时候,select的from后的目标表不能是,update的目标表 参考链接: https://blog.csdn.net/qq_38522268/article/details/93173333