Yeva__的博客

https://www.cnblogs.com/linjiqin/p/5270938.html

译文：表“course”被指定两次，一次作为“UPDATE”的目标，另一次作为单独的数据源作者SQL语句写错为：update course set courseID=(select courseID from course where courseID=‘xxx’);正确为：update table2 set courseID=(select courseID from course whe...