低版本的mysql不支持子查询 还有就是,先select ID FROM ADMIN一下看看结果对不对
mysql是4.0的 select ID FROM ADMIN结果是对的
4.0不支持子查询,解决方法是用外连接代替子查询:select * from admin where id not in (select ID FROM ADMIN ) order by id desc 等价于 SELECT admin.* FROM admin LEFT JOIN table2 ON admin.id=table2.id WHERE table2.id IS NULL order by admin.id desc ;
还有就是,先select ID FROM ADMIN一下看看结果对不对
等价于
SELECT admin.* FROM admin LEFT JOIN table2 ON admin.id=table2.id WHERE table2.id IS NULL order by admin.id desc ;