如何使用当前数据库的名称在MySQL中删除它？

要获取当前数据库，可以使用SELECT DATABASE()−

select database();

以下是语法−

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

让我们执行上面的查询，以获取当前数据库并将其删除−

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)

为了检查现在是否存在数据库，请使用SELECT DATABASE()−

mysql> select database();

这将生成以下输出−

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

阅读更多：MySQL 教程