MySQL基础视图

create view student_age as 
select * from student where age;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `student_age_20` AS select `student`.`id` AS `id`,`student`.`createDate` AS `createDate`,`student`.`userName` AS `userName`,`student`.`pwd` AS `pwd`,`student`.`phone` AS `phone`,`student`.`age` AS `age`,`student`.`sex` AS `sex`,`student`.`introduce` AS `introduce` from `student` where (`student`.`age` > 20)