2020/11/08 刘一辰的JAVA随笔

今日目标：Mysql学习13

实验内容：

-- 6.查询student表中'95031'班或者性别为'女'的同学记录

 

SELECT * FROM student WHERE s_class = '95031' OR s_sex = '女';

+------+--------+-------+---------------------+---------+

| s_no | s_name | s_sex | s_birthday          | s_class |

+------+--------+-------+---------------------+---------+

| 102  | 匡明   | 男    | 1975-10-02 00:00:00 | 95031   |

| 103  | 王丽   | 女    | 1976-01-23 00:00:00 | 95033   |

| 105  | 王芳   | 女    | 1975-02-10 00:00:00 | 95031   |

| 106  | 陆军   | 男    | 1974-06-03 00:00:00 | 95031   |

| 108  | 张全蛋 | 男    | 1975-02-10 00:00:00 | 95031   |

| 109  | 赵铁柱 | 男    | 1974-06-03 00:00:00 | 95031   |

+------+--------+-------+---------------------+---------+