#MYSQL DROP DATABASE CODE#
#MYSQL DROP DATABASE PASSWORD#

You can also confirm the presence and dropping of databases at each stage while performing this task by using the SHOW DATABASES command that gives the list of all the databases present on your database server at that particular moment when this command is executed. It can be seen that the database is dropped successfully and that no rows are returned and affected as mysqlDropDemo database contained no tables in it. That now results in the following output: We will be executing the following query statement – Now if execute the same query of DROP SCHEMA then the output will be different. Let us create the database named mysqlDropDemo using the following query – It can be seen that one warning is raised. Now, let us execute the same query with IF EXISTS clause in it – It throws an error saying no database named mysqlDropDemo exists in my database server.

The output of the above query execution is as follows: Let us try to delete the database named mysqlDropDemo using the following query statement – This functions in the same manner as that of the DROP DATABASE command. Hence, we can make the use ofĭROP SCHEMA name_of_database In MySQL, the database and schema are used interchangeably which means both are referred to the same thing and are synonyms of each other. The DROP DATABASE command gives the return value as the number of the tables that were present in that database and got deleted when dropping the database.

It can be concluded that the query executed successfully without any errors or warnings and returns two rows that were affected. Now, let us drop the educba database using the drop database command – Now let us create two tables named to test and developmentĪnd one more create table query for development that is as follows –Įxecution of the above query gives the following output: Now, let us create one database named educba using CREATE DATABASE command – It shows that the query was fine and no rows were affected and shows that one warning is there. It can be seen from the output that no error is raised even when educba named database doesn’t exist on our database. The output of the execution of the above query is as shown below: Now, let us study the output after adding the IF EXISTS clause in our query statement –

#MYSQL DROP DATABASE CODE#

Now, let us try to delete the database that is not present on our database server and see the outputs –Įxecuting the above command gives the following output:Īs it can be seen that an error with error code 1008 is thrown saying that ‘educba’ database cannot be dropped as no such database exists. That gives the following output in my case: Then you will have to execute the following command to list out all the databases that are present in your MySQL database server.

#MYSQL DROP DATABASE PASSWORD#

Provided if you wish to login with root as the username and further, it will prompt for the password if any password is set.Įxecuting the above command will give you the following output: Examples of MySQL Drop Databaseįirstly we will have to open the MySQL connection using the command: IF EXISTS clause is used for the prevention of issuing an error when a database with the specified name does not exist. In that case, if we have used the IF EXISTS clause in the command then a notice is raised instead of error saying database with the specified name is not present and the execution of the DROP DATABASE command is terminated there itself. Whenever DROP DATABASE command is executed and there is no database named name_of_database present in your MySQL database server then it throws an error saying no such database present while executing this command.

Where name_of_database helps in specifying the name of the database that you wish to delete completely including its contents like tables, stored procedures, triggers, etc. Hadoop, Data Science, Statistics & othersĭROP DATABASE name_of_database

Mysql drop database