Akwụkwọ ndekọ ederede
MySQLKedu ka esi ehichapụ tebụl data?MySQL nchekwa datahichapụ iwu / nkwupụta / syntax datatable
MySQL hichapụ tebụl
Ọ dị mfe ihichapụ tebụl data na MySQL, mana ị kwesịrị ịkpachara anya mgbe ị na-ehichapụ tebụl, n'ihi na data niile ga-apụ n'anya mgbe emechara iwu nhichapụ.
ụtọ asụsụ
Ihe a bụ syntax izugbe maka ihichapụ tebụl MySQL:
DROP TABLE table_name ;
Hichapụ tebụl data na windo iwu ozugbo
Na mysql> windo ozugbo ihichapụ tebụl data SQL nkwupụta bụ WỤPỤTA TABLE :
ihe atụ
Ọmụmaatụ ndị a na-ehichapụ tebụl data 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>
Hichapụ data nwere ike iji script PHP
PHP na-eji ọrụ mysqli_query ihichapụ tebụl MySQL.
Ọrụ ahụ nwere parampat abụọ wee weghachi TRUE ma ọ bụrụ na ogbugbu ahụ gara nke ọma, ma ọ bụghị ya, ọ ga-alaghachi FALSE.
h3> syntax
mysqli_query(connection,query,resultmode);
Paramita | nkọwa |
---|---|
njikọ | Achọrọ.Na-akọwapụta njikọ MySQL iji. |
ajụjụ | Achọrọ, ezipụta eriri ajụjụ. |
ọnọdụ nsonaazụ | Nhọrọ.a na-adịgide adịgide.Nwere ike ịbụ nke ọ bụla n'ime ụkpụrụ ndị a:
|
ihe atụ
Ihe atụ na-esonụ na-eji edemede PHP ihichapụ tebụl data chenweiliang_tbl:
hichapụ tebụl 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); ?>
Mgbe emechara nke ọma, anyị enweghị ike ịhụ tebụl chenweiliang_tbl site na iji iwu a:
mysql> show tables; Empty set (0.01 sec)
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kesara "Kedu ka MySQL si ehichapụ tebụl data? MySQL Database Hichapụ Data Table Command/Statement/Syntax", ọ ga-enyere gị aka.
Nnọọ ka ị kesaa njikọ nke akụkọ a:https://www.chenweiliang.com/cwl-458.html
Nabata na ọwa Telegram nke blọgụ Chen Weiliang ka ị nweta mmelite kachasị ọhụrụ!
📚 Ntuziaka a nwere nnukwu uru, 🌟Nke a bụ ohere dị ụkọ, echefula ya! ⏰⌛💨
Kekọrịta na-amasị ma ọ bụrụ na-amasị gị!
Ịkekọrịta na mmasị gị bụ mkpali anyị na-aga n'ihu!