Re: CREATE TABLE IF NOT EXISTS behavior (should it add rows if the table doesn't exist?)

At 14:42 -0800 3/2/04, Mark Brunkhart wrote: I apologize if this has been discussed or reported as a bug (I searched a bit but couldn't find mention of it). When you create a table using the CREATE TABLE IF NOT EXISTS...SELECT syntax, what is the correct behavior if the table already exists? It sho

CREATE TABLE IF NOT EXISTS behavior (should it add rows if the table doesn't exist?)

I apologize if this has been discussed or reported as a bug (I searched a bit but couldn't find mention of it). When you create a table using the CREATE TABLE IF NOT EXISTS...SELECT syntax, what is the correct behavior if the table already exists? I had thought that no action at all would be ta