Languages

MySQL - how to create view only if not exists?

0 points
Asked by:
Dirask Community
6240

How can I create a view only if it doesn't already exist in MySQL?

1 answer
0 points
Answered by:
Dirask Community
6240

I found a solution:

We can use the following syntax so we won't get errors while trying to create a view that already exists:

CREATE VIEW IF NOT EXISTS `view_name` AS
SELECT `column1`, `column2`, ...
FROM `table_name`
WHERE condition;

Check the article below to see some practical examples:

0 comments Add comment
Native Advertising
­čÜÇ
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

ÔŁĄ´ŞĆ­čĺ╗ ­čÖé

Join