全部博文(118)
分类: 数据库开发技术
2012-11-12 10:23:35
错误语句:
DELETE from teachercontact where id in(
select MIN(c.id) as tId from teachercontact c group by c.teacherId having(count(*)>1)
))
针对以上sql:会出现
You can't specify target table 'teachercontact' for update in FROM clause
修改为: