mysql delete 别名问题 - 流星焰的日志 - 网易博客 http://wzl3585493.blog.163.com/blog/static/7615611020126188377970/
select s.* from student s where s.id in (1,2,3);(执行成功)
结果处理：
1.不用别名
如：
delete from student where id in (1,2,3);(执行成功)
2.在delete后也加入别名
如：
delete s from student s where s.id in (1,2,3);(执行成功)
原文：http://www.cnblogs.com/ganymede/p/4063287.html