select*from students.stu_info
where class_id in(‘c01’,‘c02’);-- 在(‘c01’,‘c02’)的范围;
select*from students.stu_info
where class_id not in(‘c01’,‘c02’);-- 不在(‘c01’,‘c02’)的范围;
select distinct s_addr as ‘城市’ from students.stu_info
; – 把相同的合并在一起
selectfrom students.course
where credit=4;-- 查找学分为4的课程;
selectfrom students.class
limit 5;-- 显示前5行数据
select*from students.stu_info
where s_name like ‘李%’;-- 寻找姓氏为李的学生;