Me pehea te whakakore a MySQL i te ripanga raraunga? Ko te papaaarangi MySQL ka muku i te whakahau ripanga raraunga / korero / wetereo

Me pēhea te muku i tētahi ripanga i roto i te MySQL ? Ngā whakahau/tauākī/pūrākau muku ripanga pātengi raraunga MySQL

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 matapihi whakahau mysql>, ko te tauākī SQL hei muku i tētahi ripanga ko DROP TABLE :

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

Akoranga

Ko te tauira e whai ake nei ka whakamahi i te tuhinga PHP hei muku i te ripanga raraunga chenweiliang_tbl:

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