Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to delete the database by mysql". In the daily operation, I believe that many people have doubts about how to delete the database by mysql. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts about "how to delete the database by mysql". Next, please follow the editor to study!

In mysql, you can use the "DROP DATABASE" statement to delete the database in the syntax format "DROP DATABASE [IF EXISTS] database name;"; the optional clause "IF EXISTS" is used to prevent errors when the database does not exist.

The operating environment of this tutorial: windows10 system, mysql8 version, Dell G3 computer.

The method of deleting Database in mysql

Deleting a database means that all data and associated objects in the database are permanently deleted and cannot be undone. Therefore, it is important to execute this query with additional considerations.

To delete a database, use the DROP DATABASE statement, as follows:

DROP DATABASE [IF EXISTS] database name

Following DROP DATABASE is the name of the database to be deleted. Like the CREATE DATABASE statement, IF EXISTS is an optional part of the statement to prevent errors when you delete a database that does not exist in the database server.

If you want to practice using DROP DATABASE statements, you can create a new database and then delete it. Take a look at the following query:

CREATE DATABASE IF NOT EXISTS tempdb;SHOW DATABASES;DROP DATABASE IF EXISTS tempdb

The three statements are described as follows:

First, a database named tempdb is created using the CREATE DATABASE statement.

Second, use the SHOW DATABASES statement to display all databases.

Third, the database named tempdb is deleted using the DROP DATABASE statement.

At this point, the study on "how to delete the database by mysql" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.