Ìwé Directory
MySQLBawo ni lati pa tabili data rẹ?MySQL databasepa aṣẹ datatable / gbólóhùn / sintasi
MySQL pa tabili
O rọrun pupọ lati pa awọn tabili data rẹ ni MySQL, ṣugbọn o yẹ ki o ṣọra pupọ nigbati o ba pa awọn tabili rẹ, nitori gbogbo data yoo parẹ lẹhin ṣiṣe pipaṣẹ piparẹ naa.
girama
Atẹle ni sintasi gbogbogbo fun piparẹ tabili MySQL kan:
DROP TABLE table_name ;
Pa data tabili ni pipaṣẹ window window
Ninu mysql> window tọ aṣẹ pipaṣẹ tabili tabili data SQL jẹ SINU TABI :
Apeere
Apẹẹrẹ atẹle npa tabili data rẹ 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>
Pa datatable lilo PHP akosile
PHP nlo iṣẹ mysqli_query lati pa awọn tabili MySQL rẹ.
Iṣẹ naa ni awọn paramita meji ati pada TÒÓTỌ ti ipaniyan ba ṣaṣeyọri, bibẹẹkọ o pada FALSE.
h3> sintasi
mysqli_query(connection,query,resultmode);
Apaadi | apejuwe |
---|---|
Isopọ | Ti beere fun.Ni pato asopọ MySQL lati lo. |
query | Ti beere fun, pato okun ibeere naa. |
esimode | iyan.kan ibakan.O le jẹ eyikeyi ninu awọn iye wọnyi:
|
Apeere
Apẹẹrẹ atẹle yii nlo iwe afọwọkọ PHP lati pa tabili data rẹ chenweiliang_tbl:
pa tabili 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); ?>
Lẹhin ipaniyan aṣeyọri, a ko le rii tabili chenweiliang_tbl nipa lilo aṣẹ atẹle:
mysql> show tables; Empty set (0.01 sec)
Ireti Chen Weiliang Blog ( https://www.chenweiliang.com/ ) pín "Bawo ni MySQL ṣe pa awọn tabili data rẹ? MySQL Data Paarẹ Data Tabili Aṣẹ/Gbólóhùn/Syntax”, yoo ran ọ lọwọ.
Kaabo lati pin ọna asopọ ti nkan yii:https://www.chenweiliang.com/cwl-458.html
Kaabọ si ikanni Telegram ti bulọọgi Chen Weiliang lati gba awọn imudojuiwọn tuntun!
📚 Itọsọna yii ni iye nla, 🌟Eyi jẹ aye to ṣọwọn, maṣe padanu rẹ! ⏰⌛💨
Pin ati fẹran ti o ba fẹ!
Pinpin rẹ ati awọn ayanfẹ jẹ iwuri wa lemọlemọfún!