如何“提取” mysql查看对象？

发布于 2024-11-08 02:50:29 字数 392 浏览 0 评论 0原文

我只想以以下格式转储 mysql 数据库中的视图对象：

CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW 
`v_sample` AS 
SELECT
  `a`.`id`                  AS `id`,
  `a`.`code`                AS `active`,
  `a`.`title`               AS `title`
FROM t_test a;

上面的脚本是我曾经遇到过的最佳实践...没有权限问题，例如无法删除临时视图表等

。我在转储脚本数据库中发现，mysql首先将视图对象视为表，然后将被真实视图替换。

原文

I want to dump only view object from mysql databases in the following format :

CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW 
`v_sample` AS 
SELECT
  `a`.`id`                  AS `id`,
  `a`.`code`                AS `active`,
  `a`.`title`               AS `title`
FROM t_test a;

the script above is the best practive i have ever had... no problem with privilege issue like can not drop the temporary view table, etc

Notes :
I found inside the dump script database, that mysql treat the view object as table first then will be replaced by the real view.

分享到QQ

分享到微博