Kalozera wa Nkhani
MySQLMomwe mungachotsere tebulo la data?MySQL databaseChotsani datatable command/statement/syntax
MySQL chotsani tebulo
Ndikosavuta kufufuta matebulo a data mu MySQL, koma muyenera kusamala mukachotsa matebulo, chifukwa deta yonse idzazimiririka mukamaliza kutsitsa.
galamala
Zotsatirazi ndizomwe zimapangidwira pakuchotsa tebulo la MySQL:
DROP TABLE table_name ;
Chotsani tebulo la data pawindo la lamulo mwamsanga
Mu mysql> lamulo mwamsanga zenera chotsani deta tebulo SQL statement ndi DROP TABLE :
Chitsanzo
Chitsanzo chotsatirachi chimachotsa tebulo la 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>
Chotsani datatable pogwiritsa ntchito PHP script
PHP imagwiritsa ntchito mysqli_query ntchito kuchotsa matebulo a MySQL.
Ntchitoyi ili ndi magawo awiri ndipo imabweretsanso TRUE ngati ntchitoyo ikuyenda bwino, apo ayi imabwezeretsa FALSE.
h3> mawu
mysqli_query(connection,query,resultmode);
Parameti | kufotokoza |
---|---|
kugwirizana | Chofunikira.Imatchula kulumikizana kwa MySQL kuti mugwiritse ntchito. |
funso | Zofunikira, zimatchula mzere wamafunso. |
zotsatira | Zosankha.osasintha.Zitha kukhala zilizonse mwazinthu zotsatirazi:
|
Chitsanzo
Chitsanzo chotsatirachi chimagwiritsa ntchito zolemba za PHP kuchotsa tebulo la chenweiliang_tbl:
Chotsani tebulo la data
<? 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); ?>
Pambuyo pochita bwino, sitingathe kuwona tebulo la chenweiliang_tbl pogwiritsa ntchito lamulo ili:
mysql> show tables; Empty set (0.01 sec)
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) adagawana "Kodi MySQL imachotsa bwanji matebulo a data? MySQL Database Chotsani Table Table Command/Statement/Syntax", ikuthandizani.
Takulandirani kugawana ulalo wa nkhaniyi:https://www.chenweiliang.com/cwl-458.html
Takulandilani panjira ya Telegraph yabulogu ya Chen Weiliang kuti mupeze zosintha zaposachedwa!
📚 Bukuli lili ndi phindu lalikulu, 🌟Uwu ndi mwayi wosowa, musaphonye! ⏰⌛💨
Share ndi like ngati mukufuna!
Kugawana kwanu ndi zomwe mumakonda ndizomwe zimatilimbikitsa nthawi zonse!