如何在 MySQL 中使用当前数据库的名称来删除它?
mysqlmysqli database
要获取当前数据库，您可以使用 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 参考教程 - 该教程包含有关 mysql 的更多信息:https://www.cainiaomax.com/mysql/
