//1 创建视图
CREATE VIEW Record AS
SELECT id,name,telephone,address as diZhi
FROM user_bind_record
//2查看视图
SELECT * from Record
//3 修改视图
ALTER VIEW Record AS
SELECT id,name,age
FROM user_bind_record
WHERE age > 18
//4 删除视图
DROP view Record
2 sql视图 增删改查等操作
于 2023-11-27 09:29:04 首次发布