Error No. : #1008
Error Type : Server Error
Error Code : SSQLSTATE: HY000 (ER_DB_DROP_EXISTS)
Error Message: Can't drop database '%s'; database doesn't exist Server Error
MySQL 1008 Error DROP
This is again a very Trivial MySQL error. The Server returns error code 1008 i.e. ER_DB_DROP_EXISTS when you try to execute a DROP Command to delete a database that does not exist.
SQL query:drop database mydb
MySQL said: Documentation
#1008 - Can't drop database 'mydb'; database doesn't exist If you have a script that contains DROP command check if its getting executed twice or the database really exists.
More Posts related to MySQL,
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL Query for Schema/Structure of a Table
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- Connection Failed: 1130 PHP MySQL Error
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- How to find AUTO_INCREMENT Fields value in MySQL table
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- How to clear MySQL Console Screen
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- Fix MySQL ERROR 1045 (28000): Access denied for user root@localhost (using password: YES)
- Display List of Databases in mysql Command Line
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- Fix MySQL - Error: (OperationalError) (HY000) [08S01] Communications link failure
- MySQL: How to Select Database via Terminal/Command Line
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- Identify MySQL version in MySQL Command Line Prompt
More Posts:
- Change Terminal Cursor Type in Mac (MacOS Shell) - MacOS
- Maven Central Repository: URL and Details - Java
- Android: Maps and Places using Maps SDK - Android
- Android: programmatically turn Bluetooth on or off using Java code - Android
- Trigger Flow on selected Listitem from SharePoint view - create button with JSON column formatting - SharePoint
- Bash command to wait for seconds - Bash
- JBoss stuck loading JBAS015899: AS 7.1.1.Final Brontes starting - Java
- Change CSS Background Opacity with Examples - CSS
