Mysql drop database details, dropdatabase

Mysql drop database details, dropdatabase

Mysql deletes database drop database

Method-: Use cmd mode to download and delete

Mysql> drop database school;

This name deletes the school database. However, if the school database does not exist, an error is returned. Therefore, the complete statement should be written as follows:

Mysql> drop database if exists school;

Method 2: delete a database using a PHP script

In php, we can use the mysql_query function to execute SQL statements. Therefore, when deleting a database, we can directly use mysql_query to execute the DELETE command.

<? Php $ dbhost = 'localhost: 100'; $ dbuser = 'root'; $ dbpass = 'rootpassword'; $ conn = mysql_connect ($ dbhost, $ dbuser, $ dbpass ); if (! $ Conn) {die ('could not connect :'. mysql_error ();} echo 'connected successfully <br/> '; $ SQL = 'drop database tutorials'; $ retval = mysql_query ($ SQL, $ conn); if (! $ Retval) {die ('could not delete database: '. mysql_error ();} echo "Database TUTORIALS deleted successfullyn"; mysql_close ($ conn);?>

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!