mysql数据库操作之查找没有缺考的学生案例代码
语法代码:
- select * from stu where ch is not null and math is not null;
复制代码 运行结果如下:
- +--------+----------+--------+--------+---------+------------+------+------+
- | stuNo | stuName | stuSex | stuAge | stuSeat | stuAddress | ch | math |
- +--------+----------+--------+--------+---------+------------+------+------+
- | s25302 | 李文才 | 男 | 31 | 3 | 上海 | 77 | 76 |
- | s25303 | 李斯文 | 女 | 22 | 2 | 北京 | 55 | 82 |
- | s25305 | 诸葛丽丽 | 女 | 23 | 7 | 河南 | 72 | 56 |
- | s25318 | 争青小子 | 男 | 26 | 6 | 天津 | 86 | 92 |
- | s25319 | 梅超风 | 女 | 23 | 5 | 河北 | 74 | 67 |
- | s25320 | Tom | 男 | 24 | 8 | 北京 | 65 | 67 |
- | s25321 | Tabm | 女 | 23 | 9 | 河北 | 88 | 77 |
- +--------+----------+--------+--------+---------+------------+------+------+
- 7 rows in set (0.00 sec)
复制代码
|
|