MySQL 基础七 视图
-- 查看表 SELECT * FROM student; SHOW CREATE TABLE student; -- 创建视图 CREATE VIEW v_student1 AS SELECT *FROM student; -- 查看视图 SHOW CREATE VIEW v_student; SELECT *FROM v_student; -- 修改视图 CREATE OR REPLACE VIEW v_student1 AS SELECT id FROM student; SELECT *FROM v_student1 -- 删除视图 DROP VIEW v_student1;
天生我材必有用,千金散尽还复来