Papa Kuhikuhi ʻatikala
MySQL holoi mai ka hoʻohana ʻana?MySQL waihonahoʻopau ʻōlelo
ʻO ka ʻōlelo MySQL DELETE
Hiki iā ʻoe ke hoʻohana i ke kauoha SQL DELETE FROM e holoi i nā moʻolelo ma kahi papa ʻikepili MySQL.
hiki iā ʻoe MySQL> E hoʻokō i ke kauoha mai kahi kauoha kauoha a i ʻole kahi palapala PHP.
ʻōlelo ʻōlelo
ʻO kēia ka syntax maʻamau o ka ʻōlelo SQL DELETE e holoi i ka ʻikepili mai kahi papa ʻikepili MySQL:
DELETE FROM table_name [WHERE Clause]
- Inā ʻaʻohe wahi WHERE i kuhikuhi ʻia, e holoi ʻia nā moʻolelo āpau ma ka papa MySQL.
- Hiki iā ʻoe ke kuhikuhi i kekahi kūlana ma ka māhele WHERE
- Hiki iā ʻoe ke holoi i nā moʻolelo i ka manawa hoʻokahi i ka papa hoʻokahi.
He mea maikaʻi loa ka paukū WHERE inā makemake ʻoe e holoi i nā moʻolelo i kuhikuhi ʻia ma ka papa ʻikepili.
Holoi i ka ʻikepili mai ka laina kauoha
Maanei e hoʻohana mākou i ka māhele WHERE i ke kauoha SQL DELETE e holoi i ka ʻikepili i koho ʻia mai ka papa ʻikepili MySQL chenweiliang_tbl.
laʻana
E hoʻopau kēia laʻana i ka moʻolelo me chenweiliang_id 3 ma ka papa chenweiliang_tbl:
Hōʻike SQL UPDATE:
Holoi i ka ʻikepili me ka hoʻohana ʻana i ka palapala PHP
Hoʻohana ʻo PHP i ka hana mysqli_query() no ka hoʻokō ʻana i nā ʻōlelo SQL. Hiki iā ʻoe ke hoʻohana i ka paukū WHERE me ke kauoha SQL DELETE a i ʻole.
Hana kēia hana me MySQL> ʻO ka hopena o ke ʻano kauoha e hoʻokō nei i ke kauoha SQL ua like ia.
laʻana
E hoʻopau kēia hiʻohiʻona PHP i ka moʻolelo me chenweiliang_id 3 ma ka papa chenweiliang_tbl:
MySQL DELETE pauku hōʻike:
<? php $dbhost = 'localhost:3306'; // mysql服务器主机地址 $dbuser = 'root'; // mysql用户名 $dbpass = '123456'; // mysql用户名密码 $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('连接失败: ' . mysqli_error($conn)); } // 设置编码,防止中文乱码 mysqli_query($conn , "set names utf8"); $sql = 'DELETE FROM chenweiliang_tbl WHERE chenweiliang_id=3'; mysqli_select_db( $conn, 'chenweiliang' ); $retval = mysqli_query( $conn, $sql ); if(! $retval ) { die('无法删除数据: ' . mysqli_error($conn)); } echo '数据删除成功!'; mysqli_close($conn); ?>
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kaʻana like "MySQL holoi mai ka hoʻohana ʻana? ʻO ka ʻōlelo hoʻopau i ka waihona MySQL" kōkua iā ʻoe.
Welina mai e kaʻana like i ka loulou o kēia ʻatikala:https://www.chenweiliang.com/cwl-472.html
Welina mai i ke kahawai Telegram o ka moʻomanaʻo ʻo Chen Weiliang e kiʻi i nā mea hou loa!
📚 He waiwai nui kēia alakaʻi, 🌟He manawa kakaikahi kēia, mai poina! ⏰⌛💨
Kaʻana like a like inā makemake ʻoe!
ʻO kāu kaʻana like a me kou makemake ʻo kā mākou hoʻoikaika mau!