mysql仅在不存在时创建视图 [英] mysql create view only if it doesn't already exist

问题描述

仅在不存在视图时如何创建视图.如果确实存在，我想删除视图并重新定义它.我也不要警告或错误.

解决方案

您将踢自己:

CREATE OR REPLACE VIEW ...

此处的详细信息.;-)

How do I create a view only if it doesn't exist. If it does exist, I want to drop the view and redefine it. I also want no warnings or errors.

解决方案

You're going to kick yourself:

CREATE OR REPLACE VIEW ...

Details here. ;-)

这篇关于mysql仅在不存在时创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！