Pehea e holoi ai ʻo MySQL i kahi waihona?Holoi i ka MySQL database command/syntax/statement

MySQLPehea e holoi ai i ka waihona? holoiMySQL waihonaKauoha/syntax/'ōlelo

MySQL holoi i ka waihona

E hoʻohana i ka mysqladmin e holoi i ka waihona

E komo i ka mysql server ma ke ʻano he mea hoʻohana maʻamau. Pono ʻoe i nā ʻae kikoʻī e hana a holoi paha i kahi waihona MySQL.

No laila, hoʻohana mākou i ka mea hoʻohana kumu e komo ai ma ʻaneʻi. ʻO ka mea hoʻohana kumu ka mana kiʻekiʻe loa a hiki ke hoʻohana i ke kauoha mysql mysqladmin e hana i kahi waihona.

E akahele loa i ka holoi ʻana i kahi waihona no ka mea e nalowale nā ​​​​ʻikepili āpau ma hope o ka hoʻokō ʻana i ke kauoha holoi.

Hoʻopau kēia laʻana i ka waihona chenweiliang (ua hana ʻia ka waihona ma ka mokuna mua):

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

Ma hope o ka hoʻokō ʻana i ke kauoha i luna e holoi i ka waihona, e hōʻike ʻia kahi pahu wikiwiki e hōʻoia inā ua holoi ʻia ka waihona:

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

Holoi i ka waihona me ka PHP script

Hoʻohana ʻo PHP i ka hana mysqli_query e hana a holoi paha i nā waihona 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.

ʻōlelo ʻōlelo

mysqli_query(connection,query,resultmode);

laʻana

Hōʻike kēia hiʻohiʻona i ka hoʻohana ʻana i ka PHP mysqli_query hana e holoi i kahi waihona:

<?
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 hoʻokō pono ʻana, ʻo ka hopena:

ua holomua ka pilina

Holoi ʻia ka waihona chenweiliang

Kākau: I ka hoʻohana ʻana i kahi palapala PHP e holoi i kahi waihona, ʻaʻohe memo hōʻoia e ʻike ʻia, a e holoi pololei ʻia ka waihona i ʻōlelo ʻia, no laila pono ʻoe e makaʻala loa i ka holoi ʻana i ka waihona.