How to use the name of the current database to delete it in MySQL?

To get the current database, you can use the SELECT DATABASE() −

select database();

Following is the syntax −

set @anyVariableName = database();
select @anyVariableName;
set @anyVariableName2 = concat('drop database ', @yourVariableName);
prepare anyVariableName3 from @yourVariableName2;
execute yourVariableName3;

Let us execute the above query in order to get current database and delete it −

mysql> set @currentDatabase = database();
Query OK, 0 rows affected (0.00 sec)

mysql> select @currentDatabase;
+------------------+
| @currentDatabase |
+------------------+
| employeeonboard  |
+------------------+
1 row in set (0.00 sec)

mysql> set @sqlQuery = concat('drop database ', @currentDatabase);
Query OK, 0 rows affected (0.00 sec)

mysql> prepare stmt from @sqlQuery;
Query OK, 0 rows affected (0.04 sec)
Statement prepared

mysql> execute stmt;
Query OK, 0 rows affected (0.56 sec)

In order to check whether the database exists now, use the SELECT DATABASE() −

mysql> select database();

This will produce the following output −

+------------+
| database() |
+------------+
| NULL       |
+------------+
1 row in set (0.00 sec)

AmitDiwan

Published on 19-Nov-2020 12:28:14

• Related Questions & Answers
• Insert current date to the database in MySQL?
• How to display the name of the Current Thread in C#?
• How to get the name of the current executable in C#?
• How to get the table name of the current ResultSet using JDBC?
• How to get all the MySQL triggers and the triggers for only the current database
• How to delete data in a MySQL database with Java?
• Fetching the name of the current thread in Java
• How to alter the database engine of a MySQL database table?
• How to use Boto3 to delete a database from AWS Data Catalog?
• How can we delete a MySQL stored function from the database?
• How to get the first day of the current month in MySQL?
• How to update the current delimiter in MySQL?
• How to determine the current delimiter in MySQL?
• How to find the name of a column in MySQL?
• How to get the size of the tables of a MySQL database?