笔记：Mysql数据库删除报错 1008

作者：weixin_40725706 | 2024-03-29 21:20:59

踩

说明

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
5 rows in set (0.02 sec)
1
2
3
4
5
6
7
8
9
10
11

数据库存在
删除报错

mysql> drop database test;
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
1
2

解决方案

drop database if exists test;
1

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/weixin_40725706/article/detail/337482