MySQL Drop Database
DROP Database using MySQL Command Line Client
Using the MySQL Command Line Interface (CLI), the DROP DATABASE command is executed with the database name specified:
DROP DATABASE database_name;
Explanation: This command permanently erases the specified database, so ensure the correct database name is used to prevent unintended deletions.
Create the Database using the Command Line Interface,
Query:
CREATE DATABASE library;
Retrieve the List of Database to Confirm that the Database is Created Successfully.
SHOW DATABASES;
-Drop the Database library using the following Command.
DROP DATABASE library;
Verifying that the database library is deleted successfully from the list of databases
SHOW DATABASES;
Conclusion
In this article, we learn that the DROP DATABASE command in MySQL provides a method to permanently delete the databases. It removes the database which is no longer needed for data storing purposes. While dropping the database we need to take care while using this command is crucial, as it irreversibly erases all data within the specified database. We cannot perform a Rollback operation when the DROP DATABASE command is used, so need to use it carefully.
No comments:
Post a Comment