Tuhinga Tuhinga
MySQLMe pehea te whakakore i te ripanga raraunga?pātengi raraunga MySQLwhakakorehia te whakahau raraunga/tauākī/whakaritenga
MySQL muku tepu
He tino ngawari ki te whakakore i nga ripanga raraunga i MySQL, engari me tino tupato koe ina mukua e koe nga ripanga, na te mea ka ngaro nga raraunga katoa i muri i te mahi i te whakahau whakakore.
wetereo
E whai ake nei te wetereo whanui mo te whakakore i te ripanga MySQL:
DROP TABLE table_name ;
Mukua te ripanga raraunga i te matapihi wawe whakahau
I roto i te mysql> matapihi whakahau wawe muku te ripanga raraunga tauākī SQL ko TE TAPA RUKA :
Akoranga
Ko te tauira e whai ake nei ka muku i te ripanga raraunga chenweiliang_tbl:
root@host# mysql -u root -p Enter password:******* mysql> use chenweiliang; Database changed mysql> DROP TABLE chenweiliang_tbl Query OK, 0 rows affected (0.8 sec) mysql>
Mukua te ripanga raraunga ma te whakamahi i te tuhinga PHP
Ka whakamahia e PHP te mahi mysqli_query hei muku i nga ripanga 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.
h3> 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 ka whakamahi i te tuhinga PHP hei muku i te ripanga raraunga chenweiliang_tbl:
muku te ripanga 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); ?>
I muri i te angitu o te mahi, kaore e taea te kite i te ripanga chenweiliang_tbl ma te whakamahi i te whakahau e whai ake nei:
mysql> show tables; Empty set (0.01 sec)
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "Me pehea te whakakore a MySQL i nga ripanga raraunga? MySQL Raraunga Raraunga Mukua Ripanga Raraunga Whakahau/Tauranga/Wetereo", ka awhina koe.
Nau mai ki te tohatoha i te hono o tenei tuhinga:https://www.chenweiliang.com/cwl-458.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!