1.模糊查询
SELECT * FROM mytable WHERE u_name LIKE '%01%'
2.创建视图
create view stu_mj
as
select student.NO,student.NAME,student.SEX,student.BIRTHDAY,student.MEMBER,major.MAJOR
from student,major
where student.MAJOR_KEY=major.MAJOR_KEY
1.模糊查询
SELECT * FROM mytable WHERE u_name LIKE '%01%'
2.创建视图
create view stu_mj
as
select student.NO,student.NAME,student.SEX,student.BIRTHDAY,student.MEMBER,major.MAJOR
from student,major
where student.MAJOR_KEY=major.MAJOR_KEY