Isalathiso senqaku
MySQLIndlela yokucima itafile yedatha?MySQL databasecima umyalelo wedatha/ingxelo/isintaksi
Itafile yokucima i-MySQL
Kulula kakhulu ukucima iitafile zedatha kwi-MySQL, kodwa kufuneka uqaphele kakhulu xa ucima iitafile, kuba yonke idatha iya kunyamalala emva kokuphumeza umyalelo wokucima.
Igrama
Oku kulandelayo sisintaksi ngokubanzi yokucima itafile yeMySQL:
DROP TABLE table_name ;
Cima idatha yetafile kwifestile yomyalelo womyalelo
Kwi-mysql> iwindow ye-prompt ye-command cima itafile yedatha i-SQL statement is YIYIPHI ITABILE :
Umzekelo
Lo mzekelo ulandelayo ucima idatha yetafile 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>
Cima idatha yedatha usebenzisa iscript sePHP
I-PHP isebenzisa umsebenzi we-mysqli_query ukucima iitafile ze-MySQL.
Umsebenzi uneparameters ezimbini kwaye ubuyisela TRUE ukuba uphumezo luphumelele, kungenjalo ibuyisela FALSE.
h3> isintaksi
mysqli_query(connection,query,resultmode);
IParamu | inkcazo |
---|---|
uqhagamshelwano | Kufuneka.Ixela uqhagamshelwano lweMySQL oluza kusetyenziswa. |
umbuzo | Okufunekayo, ikhankanya umtya wombuzo. |
imowudi yeziphumo | Ukhetho.a rhoqo.Inokuba nawaphi na amaxabiso alandelayo:
|
Umzekelo
Lo mzekelo ulandelayo usebenzisa iscript sePHP ukucima itafile yedatha chenweiliang_tbl:
cima idatha yetafile
<? 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); ?>
Emva kokuphunyezwa ngempumelelo, asikwazi ukubona itafile ye-chenweiliang_tbl ngokusebenzisa lo myalelo ulandelayo:
mysql> show tables; Empty set (0.01 sec)
Ndiyathemba Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwana "Izicima njani iitafile zedatha iMySQL? I-MySQL Database Cima iThebhile yeDatha Umyalelo / iNgxelo / iSyntax", iya kukunceda.
Wamkelekile ukwabelana ngekhonkco leli nqaku:https://www.chenweiliang.com/cwl-458.html
Wamkelekile kwisitishi seTelegram sebhlog kaChen Weiliang ukufumana uhlaziyo lwamva nje!
📚 Esi sikhokelo sinexabiso elikhulu, 🌟Eli lithuba elinqabileyo, ungaliphoswa! ⏰⌛💨
Yabelana kwaye uthanda ukuba uyathanda!
Ukwabelana kwakho kunye nezinto ozithandayo ziyinkuthazo yethu eqhubekayo!