04 2011 档案

关于mysql delete的问题
摘要：由于mysql数据库的相关内部问题导致delete from table wherecol not in (select col from table group by xx)会提示报错我们要做的是create table tmp selete col from table group by xx;delete from table where col not in (select col from tmp);drop table tmp; 阅读全文
posted @ 2011-04-27 10:42 hellovigoss 阅读(254) 评论(0) 推荐(0) 编辑