这几天忙着写java作业,
学会了一条mysql语句:
创建视图:create view viewName as ......;
例如:select person.id,person.name,department.dname,person.occupation,person.salary,education.ename from person,department,education where person.depid = department.depid AND person.eduid = education.eduid