MySQL inodzima sei database?Delete MySQL database command/syntax/statement

MySQLNzira yekubvisa sei database?deleteMySQL databaseCommand/Syntax/Statement

MySQL bvisa database

donhedza database uchishandisa mysqladmin

Pinda kune mysql server semushandisi akajairwa, ungangoda maropafadzo chaiwo kugadzira kana kudzima MySQL dhatabhesi.

Saka isu tinoshandisa mudzi wemushandisi kupinda pano.Mudzi wemudzi ane chiremera chepamusoro uye anogona kushandisa mysql mysqladmin command kugadzira dhatabhesi.

Ngwarira zvakanyanya paunenge uchidzima dhatabhesi, sezvo data rese richange raenda mushure mekunge murairo wekudzima waitwa.

Muenzaniso unotevera unodzima dhatabhesi chenweiliang (iyo dhatabhesi yakagadzirwa muchitsauko chapfuura):

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

Mushure mekuita murairo uri pamusoro wekudzima dhatabhesi, bhokisi rekukurumidza richaonekwa kuratidza kuti dhatabhesi yakadzimwa chaizvo:

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 [y/N] y
Database "chenweiliang" dropped

Bvisa dhatabhesi uchishandisa PHP script

PHP inoshandisa mysqli_query basa kugadzira kana kudzima MySQL dhatabhesi.

Basa racho rine maparamendi maviri uye rinodzorera TRUE kana kuurayiwa kwabudirira, zvikasadaro inodzorera FALSE.

girama

mysqli_query(connection,query,resultmode);

muenzaniso

Muenzaniso unotevera unoratidza kushandiswa kweiyo PHP mysqli_query basa kudzima dhatabhesi:

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

Mushure mekubudirira kuurayiwa, nhamba mhedzisiro ndeye:

kubatana kwabudirira

Database chenweiliang yadzimwa zvinobudirira

Ongorora: Paunenge uchidzima dhatabhesi uchishandisa PHP script, meseji yekusimbisa haizooneke, uye iyo yakatsanangurwa dhatabhesi ichabviswa zvakananga, saka iwe unofanirwa kungwarira zvakanyanya paunodzima dhatabhesi.