Me pehea te whakakore a MySQL i tetahi papaa raraunga?Mukua te whakahau paparangi raraunga MySQL / wetereo / korero

Me pēhea te muku i tētahi pātengi raraunga i roto i te MySQL ? Ngā whakahau/ngā kupu/ngā tauākī mō te muku i tētahi pātengi raraunga MySQL.

MySQL muku pātengi raraunga

maturuturu te papaa raraunga ma te whakamahi mysqladmin

Takiuru ki te tūmau mysql hei kaiwhakamahi noa, me whai mana motuhake koe ki te waihanga, ki te whakakore ranei i nga papaa raraunga MySQL.

Na ka whakamahi matou i te kaiwhakamahi pakiaka ki te takiuru ki konei Ko te kaiwhakamahi pakiaka te mana teitei ka taea te whakamahi i te tono mysql mysqladmin ki te hanga i tetahi papaa raraunga.

Me tino tupato i te wa e mukua ana he papaa raraunga, na te mea ka ngaro katoa nga raraunga i muri i te mahi i te whakahau muku.

Ko te tauira e whai ake nei ka muku i te chenweiliang pātengi raraunga (i hangaia te pātengi raraunga i te upoko o mua):

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

Whai muri i te whakahaerenga i te whakahau muku i runga ake nei, ka puta he pouaka tere ki te whakaū mena kua tino mukua te patengi raraunga:

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

Muku pātengi raraunga mā te hōtuhi PHP

Ka whakamahi a PHP i te mahi mysqli_query ki te hanga, ki te muku ranei i nga papaunga raraunga MySQL.

E rua nga tawhā o te mahi ka whakahoki i te TRUE mena ka angitu te mahi, ki te kore ka hoki mai te HERE.

wetereo

mysqli_query(connection,query,resultmode);

Akoranga

Ko te tauira e whai ake nei e whakaatu ana i te whakamahinga o te mahi PHP mysqli_query ki te muku i tetahi putunga:

<?
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);
?>

Whai muri i te mahi angitu, ko te hua tau ko:

i angitu te hononga

I pai te mukua te chenweiliang pātengi raraunga

Kia mōhio: Ina whakamahia he hōtuhi PHP hei muku i tētahi pātengi raraunga, kāore he karere whakaū e whakaaturia; ka mukua tika te pātengi raraunga kua tohua. Nō reira, me tino tupato koe ina mukua ana tētahi pātengi raraunga.