DROP DATABASE [IF EXISTS] db_name
DROP DATABASE drops all tables in the database and deletes the
database. Be VERY careful with this command!
DROP DATABASE returns the number of files that were removed from the
database directory. Normally, this is three times the number of tables,
since each table corresponds to a `.ISD' file, a `.ISM' file and a
In MySQL 3.22 or later, you can use the keywords
IF EXISTS to
prevent an error from occurring if the database doesn't exist.
You can also drop databases with
12.1 Overview of the different MySQL programs.