Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to delete the database in MySQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

MySQL delete database use mysqladmin to delete database

Using ordinary users to log in to the MySQL server, you may need specific permissions to create or delete MySQL databases.

So we use the root user to log in, and the root user has the highest privileges, so we can use the mysql mysqladmin command to create the database.

Be careful when deleting a database, because all data will disappear after the delete command is executed.

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

[root@host] # mysqladmin-u root-p drop chenweiliangEnter 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 'chenweiliang' database [yramp N] yDatabase "chenweiliang" dropped uses the PHP script to delete the database

PHP uses the mysqli_query function to create or delete an MySQL database.

This function takes two arguments and returns TRUE on successful execution, or FALSE otherwise.

Syntax mysqli_query (connection,query,resultmode); parameter description connection is required. Specifies the MySQL connection to be used. Query is required, specifying the query string. Resultmode is optional. A constant. It can be any of the following values:

MYSQLI_USE_RESULT (use this if you need to retrieve a large amount of data)

MYSQLI_STORE_RESULT (default)

Example

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

Delete the database after reading the above, do you have any further understanding of how to delete the database in MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.