<database definition>::=
CREATE DATABASE [IF NOT EXISTS] <database name>
[[DEFAULT] CHARACTER SET <character set name>]
[[DEFAULT] COLLATE <collation name>]

=>what is the disadvantage of not using [IF NOT EXISTS] clause.
=> if there is no disadvantage then why we use this clause ?


waiting for reply

__________________
sandeep gupta

Ummm...simple.

If the database already exists, then the CREATE DATABASE will give you an error, "Database already exists."

If you *KNOW* the DB does not exist, you don't need the IF NOT EXISTS.

If you don't mind getting an error (e.g., if you are trapping the error in your Java/PHP/ASP/ASP.NET code), then you don't need it, either.