mysql数据库操作之查找缺考的学生案例代码
- mysql> select * from stu where ch is null or math is null;
- +--------+----------+--------+--------+---------+------------+------+------+
- | stuNo | stuName | stuSex | stuAge | stuSeat | stuAddress | ch | math |
- +--------+----------+--------+--------+---------+------------+------+------+
- | s25301 | 张秋丽 | 男 | 18 | 1 | 北京 | 80 | NULL |
- | s25304 | 欧阳俊雄 | 男 | 28 | 4 | 天津 | NULL | 74 |
- +--------+----------+--------+--------+---------+------------+------+------+
复制代码
|
|