mysql中有没有exists()函数?

roach

错误如下:

select sname from student where not exists(select * from SC
    -> where SC.sno=student.sno and cno='1');
ERROR 1064: You have an error in your SQL syntax near 'exists(select * from SC
where SC.sno=student.sno and cno='1')' at line 1

laokan

mysql 不支持子查询的吧！