Tuhinga Tuhinga
MySQLMe pēhea te muku i te pātengi raraunga?whakakorepātengi raraunga MySQLWhakahau/Wetereo/Krero
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);
Parapeta | whakaahuatanga |
---|---|
hononga | E hiahiatia ana.Ka tohua te hononga MySQL hei whakamahi. |
uiui | E hiahiatia ana, ka tohua te aho uiui. |
aratau hua | Kōwhiringa.he tuturu.Ka taea tetahi o nga uara e whai ake nei:
|
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:
muku pātengi raraunga
<? 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
Tuhipoka: I te wa e mukua ana te papaaarangi ma te whakamahi i te tuhinga PHP, karekau te karere whakapumautanga e puta mai, ka mukua tika te patengi raraunga kua tohua, no reira me tino tupato koe i te wa e mukua ana te papaaarangi.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "Me pehea te whakakore a MySQL i te papanga raraunga?Tangohia nga Tono Raraunga Raraunga MySQL/Wetereo/Tuhinga" hei awhina i a koe.
Nau mai ki te tohatoha i te hono o tenei tuhinga:https://www.chenweiliang.com/cwl-465.html
Nau mai ki te hongere Telegram o te blog a Chen Weiliang ki te tiki i nga korero hou!
📚 He uara nui tenei aratohu, 🌟He waahi onge tenei, kaua e ngaro! ⏰⌛💨
Tohaina me te pai ki te pai koe!
Ko to tiritiri me o hiahia ko to maatau hihiri tonu!