mysql create view only if it doesn't already exist

Question

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.

score 21 · Accepted Answer · answered Feb 11 '10 at 16:24

21

You're going to kick yourself:

CREATE OR REPLACE VIEW ...

answered Feb 11 '10 at 16:24

T.J. Crowder

2

darn, you beat me to it and i didn't get a notification an answer was posted already. so +1 from me. – Roland Bouman Feb 11 '10 at 16:27

score 2 · Answer 2 · answered Feb 11 '10 at 16:26

2

CREATE OR REPLACE VIEW <view name>
AS
<your select expression goes here>

answered Feb 11 '10 at 16:26

Roland Bouman

2 Answers2