立即学习:https://edu.csdn.net/course/play/4364/77154?utm_source=blogtoedu
# 使用视图添加列别名(as可以省略)、计算列
create view VTStudent
as
select studentid as 学号, sname as 姓名, birthday 生日, YEAR(now())-YEAR(birthday) 年龄
from TStudent
立即学习:https://edu.csdn.net/course/play/4364/77154?utm_source=blogtoedu
# 使用视图添加列别名(as可以省略)、计算列
create view VTStudent
as
select studentid as 学号, sname as 姓名, birthday 生日, YEAR(now())-YEAR(birthday) 年龄
from TStudent