Pehea e holoi ai ʻo MySQL i kahi papa ʻikepili? Hoʻopau ka waihona ʻikepili MySQL i ke kauoha papa ʻikepili / ʻōlelo / syntax

MySQLPehea e holoi ai i ka papa ʻikepili?MySQL waihonae holoi i ke kauoha ʻikepili/ ʻōlelo / syntax

MySQL holoi papaʻaina

He mea maʻalahi loa ka holoi ʻana i nā papa ʻikepili ma MySQL, akā pono ʻoe e makaʻala i ka wā e holoi ai i nā papa, no ka mea, e nalowale nā ​​​​ʻikepili āpau ma hope o ka hoʻokō ʻana i ke kauoha holoi.

ʻōlelo ʻōlelo

ʻO kēia ka syntax maʻamau no ka holoi ʻana i kahi papa MySQL:

DROP TABLE table_name ;

Holoi i ka papa ʻikepili ma ka puka makani kauoha

Ma ka mysql> command prompt window e holoi i ka papa ʻikepili SQL ʻōlelo PAPA PALAPALA :

laʻana

Hoʻopau kēia laʻana i ka papa ʻikepili 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>

Holoi i ka ʻikepili me ka hoʻohana ʻana i ka palapala PHP

Hoʻohana ʻo PHP i ka hana mysqli_query e holoi i nā papa MySQL.

Loaʻa i ka hana ʻelua mau ʻāpana a hoʻihoʻi i ka TRUE inā kūleʻa ka hoʻokō ʻana, inā ʻaʻole e hoʻi mai FALSE.

h3> hōʻailona

mysqli_query(connection,query,resultmode);

laʻana

Ke hoʻohana nei kēia laʻana i kahi script PHP e holoi i ka papa ʻikepili 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);
?>

Ma hope o ka holomua o ka hoʻokō ʻana, ʻaʻole hiki iā mākou ke ʻike i ka papa chenweiliang_tbl ma ka hoʻohana ʻana i kēia kauoha:

mysql> show tables;
Empty set (0.01 sec)