Tsab ntawv teev npe
MySQLYuav rho tawm cov ntaub ntawv li cas?MySQL databaserho tawm datatable hais kom ua / nqe lus / syntax
MySQL rho tawm rooj
Nws yooj yim heev rau rho tawm cov ntaub ntawv hauv MySQL, tab sis koj yuav tsum tau ceev faj heev thaum koj rho tawm cov ntxhuav, vim tias tag nrho cov ntaub ntawv yuav ploj tom qab ua tiav cov lus txib rho tawm.
qauv sau ntawv
Cov hauv qab no yog cov ntsiab lus dav dav rau kev rho tawm MySQL cov lus:
DROP TABLE table_name ;
Rho tawm cov ntaub ntawv hauv lub qhov rais hais kom ua
Hauv mysql> hais kom ua qhov rai rho tawm cov ntaub ntawv SQL nqe lus yog DROP TABLE :
piv txwv
Cov piv txwv hauv qab no tshem tawm cov ntaub ntawv rooj 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>
Rho tawm cov ntaub ntawv siv PHP tsab ntawv
PHP siv mysqli_query muaj nuj nqi los rho tawm MySQL ntxhuav.
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.
h3> syntax
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 siv cov ntawv PHP kom tshem tawm cov ntaub ntawv rooj chenweiliang_tbl:
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 kev ua tiav tiav, peb tsis tuaj yeem pom lub rooj chenweiliang_tbl los ntawm kev siv cov lus txib hauv qab no:
mysql> show tables; Empty set (0.01 sec)
Cia siab Chen Weiliang Blog ( https://www.chenweiliang.com/ ) qhia "Yuav ua li cas MySQL rho tawm cov ntaub ntawv rooj? MySQL Database Delete Data Table Command/Statement/Syntax", nws yuav pab tau koj.
Zoo siab txais tos los qhia qhov txuas ntawm kab lus no:https://www.chenweiliang.com/cwl-458.html
Zoo siab txais tos rau Telegram channel ntawm Chen Weiliang blog kom tau txais qhov hloov tshiab tshiab!
📚 Daim ntawv qhia no muaj nuj nqis loj, 🌟Qhov no yog lub sijhawm tsis tshua muaj, tsis txhob nco nws! ⏰⌛💨
Share thiab like yog tias koj nyiam!
Koj qhov kev sib koom thiab kev nyiam yog peb qhov kev txhawb nqa tas mus li!