Susa i-MySQL ekusetshenzisweni? susa isitatimende ku-database ye-MySQL

MySQL susa ekusetshenzisweni?MySQL databasesusa isitatimende

MySQL DELETE isitatimende

Ungasebenzisa umyalo we-SQL DELETE FROM ukuze ususe amarekhodi kuthebula lesizindalwazi se-MySQL.

Ungakwazi mysql> Yenza umyalo kusuka kusaziso somyalo noma iskripthi se-PHP.

uhlelo lolimi

Okulandelayo i-syntax evamile yesitatimende se-SQL DELETE ukususa idatha kuthebula ledatha ye-MySQL:

DELETE FROM table_name [WHERE Clause]

• Uma kungekho LAPHO isigatshana esishiwo, wonke amarekhodi kuthebula le-MySQL azosuswa.
• Ungacacisa noma yimuphi umbandela esigatshaneni esithi LAPHO
• Ungasusa amarekhodi wonke ngesikhathi esisodwa kuthebula elilodwa.

Isigatshana esithi LAPHO siwusizo kakhulu uma ufuna ukususa amarekhodi athile kuthebula ledatha.

Susa idatha emugqeni womyalo

Lapha sizosebenzisa isigatshana esithi WHERE kumyalo we-SQL DELETE ukuze sisuse idatha ekhethiwe kuthebula ledatha le-MySQL elithi chenweiliang_tbl.

Isibonelo

Isibonelo esilandelayo sizosusa irekhodi eline-chenweiliang_id 3 kuthebula le-chenweiliang_tbl:

Susa idatha usebenzisa umbhalo we-PHP

I-PHP isebenzisa umsebenzi we-mysqli_query() ukuze isebenzise izitatimende ze-SQL. Ungasebenzisa isigatshana esithi LAPHO noma ngaphandle komyalo we-SQL DELETE.

Lo msebenzi usebenza nawo mysql> Umphumela wohlamvu lomyalo owenza umyalo we-SQL uyafana.

Isibonelo

Isibonelo esilandelayo se-PHP sizosusa irekhodi eline-chenweiliang_id 3 kuthebula le-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);
?>