MySQL rho tawm database li cas?Rho tawm MySQL database command/syntax/statement

Yuav ua li cas rho tawm ib lub database hauv MySQL ? Cov lus txib / syntax / cov lus hais rau kev rho tawm ib lub database MySQL.

MySQL rho tawm database


poob database siv mysqladmin

Nkag mus rau hauv mysql server raws li tus neeg siv ib txwm, koj yuav xav tau cov cai tshwj xeeb los tsim lossis tshem tawm MySQL databases.

Yog li peb siv tus neeg siv hauv paus nkag mus rau ntawm no, tus neeg siv hauv paus muaj txoj cai siab tshaj plaws thiab siv tau cov lus txib mysql mysqladmin los tsim cov ntaub ntawv.

Kev saib xyuas zoo yuav tsum tau ua thaum rho tawm cov ntaub ntawv, vim tias tag nrho cov ntaub ntawv yuav ploj mus tom qab tshem tawm cov lus txib.

Cov piv txwv hauv qab no tshem tawm cov ntaub ntawv chenweiliang (cov ntaub ntawv tau tsim nyob rau hauv tshooj dhau los):

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

Tom qab ua tiav cov lus txib saum toj no rho tawm cov ntaub ntawv, lub thawv tam sim yuav tshwm sim kom paub meej tias cov ntaub ntawv puas raug tshem tawm tiag tiag:

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

Rho tawm database siv PHP tsab ntawv

PHP siv mysqli_query muaj nuj nqi los tsim lossis tshem tawm MySQL databases.

Qhov kev ua haujlwm muaj ob qhov tsis muaj thiab rov qab TRUE yog tias kev ua tiav tiav, txwv tsis pub nws rov FALSE.

qauv sau ntawv

mysqli_query(connection,query,resultmode);
Tsis描述
kev twb kev txuasYuav tsum tau.Qhia meej txog MySQL kev sib txuas siv.
lus nugYuav tsum tau, qhia cov kab lus nug.
hom kev tshwm simxaiv tau.ib qho tsis tu ncua.Yuav yog ib qho ntawm cov txiaj ntsig hauv qab no:

  • MYSQLI_USE_RESULT (siv qhov no yog tias koj xav tau khaws cov ntaub ntawv ntau)
  • MYSQLI_STORE_RESULT (default)

piv txwv

Cov piv txwv hauv qab no qhia txog kev siv PHP mysqli_query muaj nuj nqi los rho tawm cov ntaub ntawv:

rho tawm database

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

Tom qab ua tiav kev ua tiav, tus lej tshwm sim yog:

kev sib txuas ua tiav

Database chenweiliang deleted ntse

Lus Cim: Thaum siv PHP script los rho tawm ib lub database, yuav tsis muaj lus lees paub tshwm sim; lub database uas tau teev tseg yuav raug rho tawm ncaj qha. Yog li ntawd, koj yuav tsum ceev faj tshwj xeeb thaum rho tawm ib lub database.

评论 评论

您的邮箱地址不会被公开。必填项已用*标注

Scroll rau saum