MySQL cima ekusebenziseni? cima ingxelo kwisiseko sedatha yeMySQL

MySQL cima ekusebenziseni?MySQL databasecima ingxelo

MySQL DELETE ingxelo

Ungasebenzisa i-SQL DELETE FROM umyalelo wokucima iirekhodi kwitafile yedatha ye-MySQL.

Unga mysql> Phumeza umyalelo ovela kwi-prompt yomyalelo okanye iskripthi se-PHP.

Igrama

Oku kulandelayo sisintaksi ngokubanzi yengxelo yeSQL DELETE ukucima idatha esuka kwitafile yedatha yeMySQL:

DELETE FROM table_name [WHERE Clause]

• Ukuba akukho APHO igatya lichaziweyo, zonke iirekhodi kwitafile yeMySQL ziya kususwa.
• Ungakhankanya nayiphi na imeko kwigatya apho
• Ungazicima zonke iirekhodi ngexesha elinye kwitafile enye.

Igatya elithi WHERE liluncedo kakhulu xa ufuna ukucima iirekhodi ezikhankanyiweyo kwitheyibhile yedatha.

Cima idatha kumgca womyalelo

Apha siza kusebenzisa igatya elithi WHERE kumyalelo we-SQL DELETE ukucima idatha ekhethiweyo kwitheyibhile yedatha ye-MySQL chenweiliang_tbl.

Umzekelo

Lo mzekelo ulandelayo uzakucima irekhodi nge chenweiliang_id 3 kwitheyibhile ye-chenweiliang_tbl:

Cima idatha usebenzisa iscript sePHP

I-PHP isebenzisa i-mysqli_query() umsebenzi ukwenza ingxelo ye-SQL.Ungasebenzisa i-WHERE igatya kunye okanye ngaphandle komyalelo we-SQL DELETE.

Lo msebenzi usebenza nge mysql> Isiphumo sophawu lomyalelo owenza umyalelo weSQL siyafana.

Umzekelo

Lo mzekelo ulandelayo we-PHP uyakucima irekhodi nge-chenweiliang_id 3 kwitheyibhile ye-chenweiliang_tbl:

<?
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);
?>