Collections:
Deleting an Existing Database in MySQL
How To Drop an Existing Database in MySQL?
✍: FYIcenter.com
If want to drop an existing database from the MySQL server, you can use the DROP DATABASE statement. Here is a good example of dropping an existing database:
$con = mysql_connect('localhost:8888', 'dev', 'iyf'); $sql = 'DROP DATABASE fyi'; if (mysql_query($sql, $con)) { print("Database fyi dropped.\n"); } else { print("Database drop failed with error:\n"); print(mysql_errno($con).": ".mysql_error($con)."\n"); } mysql_close($con); ?>
If you run this script, you will get something like this, if "dev" does not have privilege to drop database:
Database drop failed with error: 1044: Access denied for user 'dev'@'%' to database 'fyi'
⇒ Selecting an Existing Database in MySQL
⇐ Retrieving Execution Error Message in MySQL
2017-10-23, 1445🔥, 0💬
Popular Posts:
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...