Re: Significance of /*!32312 IF NOT EXISTS*/;

2002-07-09 Thread Jeremy Zawodny
On Tue, Jul 09, 2002 at 08:51:05PM -0700, Todd Cary wrote: > In my mysql dump of a DB using the -B switch, I get > > CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc; > > What is the significance of /*!32312 IF NOT EXISTS*/ - the > "/*!32312"? Isn't the statement

Significance of /*!32312 IF NOT EXISTS*/;

2002-07-09 Thread Todd Cary
In my mysql dump of a DB using the -B switch, I get CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc; What is the significance of /*!32312 IF NOT EXISTS*/ - the "/*!32312"? Isn't the statement commented out? With the CREATE TABLE, what happens if the table already exists? Tod