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

MySQLYuav rho tawm cov ntaub ntawv li cas?rho tawmMySQL databaseCommand/Syntax/Statement

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

piv txwv

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

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

Nco tseg: Thaum rho tawm cov ntaub ntawv siv PHP tsab ntawv, cov lus lees paub yuav tsis tshwm sim, thiab cov ntaub ntawv teev tseg yuav raug muab tshem tawm ncaj qha, yog li koj yuav tsum ceev faj heev thaum rho tawm cov ntaub ntawv.