视图

最新推荐文章于 2025-04-06 03:31:23 发布

执着更专业

最新推荐文章于 2025-04-06 03:31:23 发布

阅读量350

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/pangchengyong0724/article/details/73245518

版权

mysql 专栏收录该内容

13 篇文章

订阅专栏

本文详细介绍了如何在MySQL中创建、修改、删除及查看视图的具体步骤与语法，并提供了实际的SQL语句作为示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

创建视图

DELIMITER $$
USE `test`$$

DROP VIEW
IF EXISTS `aaa`$$

CREATE 

ALGORITHM=UNDEFINED
DEFINER = `tkglobal_dba`@`localhost` 
SQL SECURITY INVOKER 

VIEW `aaa` AS 

SELECT
	*
FROM
	pit_users ;$$

DELIMITER ;

修改视图

ALTER SELECT TABLE_NAME, CHECK_OPTION, IS_UPDATABLE, DEFINER, SECURITY_TYPE FROM information_schema.VIEWS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='aaa' ORDER BY TABLE_NAME


ALGORITHM=MERGE --算法DEFINER=`tkglobal_dba`@`localhost` --定义者 SQL SECURITY INVOKER --安全性

VIEW `aaa` AS SELECT`pit_users`.`id` AS `id`,`pit_users`.`name` AS `name`,`pit_users`.`avatar` AS `avatar`,`pit_users`.`email` AS `email`,`pit_users`.`password` AS `password`,`pit_users`.`remember_token` AS `remember_token`,`pit_users`.`created_at` AS `created_at`,`pit_users`.`updated_at`
 AS `updated_at`FROM`pit_users` WITH LOCAL CHECK OPTION;--检查选项



删除视图

DROP VIEW `aaa`




查看视图：
SHOW CREATE VIEW `aaa`




查看算法 定义者 安全性 检查选项

SELECT TABLE_NAME, CHECK_OPTION, IS_UPDATABLE, DEFINER, SECURITY_TYPE FROM information_schema.VIEWS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='aaa' ORDER BY TABLE_NAME