Tsab ntawv teev npe
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 txuas | Yuav tsum tau.Qhia meej txog MySQL kev sib txuas siv. |
| lus nug | Yuav tsum tau, qhia cov kab lus nug. |
| hom kev tshwm sim | xaiv tau.ib qho tsis tu ncua.Yuav yog ib qho ntawm cov txiaj ntsig hauv qab no:
|
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
$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.
Vam tias, tsab xov xwm "Yuav ua li cas rho tawm lub database hauv MySQL? Cov lus txib/syntax/cov lus hais rau kev rho tawm lub database MySQL" uas tau muab faib rau ntawm Chen Weiliang lub blog ( https://www.chenweiliang.com/ ) yuav pab tau rau koj.
Xav qhia qhov txuas ntawm tsab xov xwm no: https://www.chenweiliang.com/cwl-465.html
