Shulou(Shulou.com)06/01 Report--

Mysql deletes the database from the command line

1. Syntax:

DROP DATABASE IF EXISTS database name

two。 Syntax parsing:

IF EXISTS: determine whether the database exists. If so, delete the corresponding database. If it does not exist, it will avoid the error of performing deletion.

3. Example:

# Delete the database whose name is demo1

DROP DATABASE IF EXISTS demo1

4. Screenshot of the running result:

Screenshot before deletion:

Take screenshots after deletion:

5. When the demo1 database does not exist and there is no IF EXISTS statement, an error will be reported when performing the delete operation, so use the IF EXISTS statement

DROP DATABASE demo1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.