关于MySQL5中的视图简单例子

关于MySQL5中的视图简单例子

create table teacher_info( ID char(8) not null, name varchar(10) not null, sex varchar(2) not null, zhengzhi varchar(10), xueli varchar(10), zhicheng varchar(10), xibie varchar(20), phone varchar(10) ) ;

CREATE VIEW teacher_view (name,sex,xibie) AS SELECT name, sex, xibie FROM teacher_info ;

insert into teacher_info values('1', '王芳', '女','','','','计算机系','') ;

select * from teacher_view;