课内学习06 — MYSQL
实验6 查询 where子句
源码如下:
1.
create database xrf;
2.
use xrf;
3.
source C:\Users\Administrator\Desktop\sy7.sql
4.
select * from xs where 专业名 is null;
5.
select * from xs where 备注 like '%补考%';
6.
select * from xs where 学号 like '%林';
7.
select * from xs where 学号 like '%1__';
8.
select * from xs where 学号 like '%\_%';
9.
select * from xs where 出生日期 like '.+-08-.+-10-.+';
10.
select * from xs where 出生日期 not between '1995-01-01' and '1995-12-31';
11.
select *from xs where 专业名 in ('计算机','通信工程');
12.
select * from xs_kc where 学号 like '%302%';