4.2.7. MySQL deletes the database

Drop command to delete database ¶

Drop command format:

drop database <数据库名>;

For example, delete a database named RUNOOB:

mysql> drop database RUNOOB;

Delete a database using mysqladmin ¶

You can also use it. mysql mysqladmin The command executes the delete command at the terminal.

The following example deletes the database RUNOOB (which was created in the previous section):

[root@host]# mysqladmin -u root -p drop RUNOOB
Enter password:******

After executing the above delete database command, a prompt box appears to confirm that the database is actually deleted:

Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'RUNOOB' database [y/N] y
Database "RUNOOB" dropped

Grammar ¶

mysqli_query(connection,query,resultmode);

Example ¶

The following example demonstrates the use of PHP mysqli_query Function to delete the database:

Delete database

<?php$dbhost='localhost';//mysql服务器主机地址$dbuser='root';//mysql用户名$dbpass='123456';//mysql用户名密码$conn=mysqli_connect($dbhost,$dbuser,$dbpass);if(!$conn){die('连接失败:'.mysqli_error($conn));}echo'连接成功<br
/>';$sql='DROP DATABASE
RUNOOB';$retval=mysqli_query($conn,$sql);if(!$retval){die('删除数据库失败:'.mysqli_error($conn));}echo"数据库
RUNOOB 删除成功\\n";mysqli_close($conn);?>

After successful execution, the results are as follows:

注意： When using the PHP script to delete the database, there will be no confirmation of whether to delete the information, but will delete the specified database directly, so you should be very careful when deleting the database.