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, 1871🔥, 0💬
Popular Posts:
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...