mysql create view only if it doesn't already exist

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.

Solution

You're going to kick yourself:

CREATE OR REPLACE VIEW ...

Details here. ;-)

Display all data when Date Range inputs are null
Snowflake join on mixed datatypes not returning results
How to insert a value that contains an apostrophe (single quote)?
Use Alias from one select to be used in another select
SQL IN Clause 1000 item limit
SQL Server: IF EXISTS massively slowing down a query
SQL-Snowflake - How to count the days between dates in 2 or more rows with WHERE condition
How to SELECT by MAX(date)?
Presto sql: presto extract substring for the last occurrence of character in string
SQL - Select first 10 rows only?
Operator precedence of `EXISTS`
mysql create view only if it doesn't already exist
How to validate data is Hexadecimal in Presto
Merge tables with different timestamps?
Wordpress - generate random unique number using atomic operation and update database
PostgreSQL ERROR: cannot accumulate arrays of different dimensionality
PostgreSQL copy row minus a few columns
SQL Server random selection
SQL to show current PTID and Next_PTID based on my example
How to add constraint if not exists
Rolling sum that resets at a flag
Why is LEFT INNER JOIN deprecated?
Left outer join on multiple tables condition
Will the CTE reflect changes in the data?
incorrect results from MAX and ORDER BY
Generate CREATE scripts for a list of indexes
How to create a deterministic uniqueidentifier (GUID) from an integer value
Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
Insert sorted rows in another table using SQL
Is there a way to prevent ROW_NUMBER's ORDER BY from having to repeat the same thing?