MySQL ka tirtir isticmaalka? tirtir bayaanka MySQL database

MySQL ka tirtir isticmaalka?database MySQLtirtir qoraalka

MySQL DELETE bayaanka

Waxaad isticmaali kartaa SQL DELETE FROM amarka si aad u tirtirto diiwaanada ku jira miiska xogta MySQL.

Waad awoodaa mysql> Ka fuli amarka deg degga ama qoraalka PHP.

naxwaha

Kuwa soo socdaa waa ereyga guud ee bayaanka SQL DELETE si loo tirtiro xogta shaxda xogta MySQL:

DELETE FROM table_name [WHERE Clause]

• Haddii aysan jirin meel lagu cayimay, dhammaan diiwaanada ku jira miiska MySQL waa la tirtiri doonaa.
• Waxaad ku qeexi kartaa xaalad kasta oo ku jirta qodobka HALKEE
• Waxaad ku tirtiri kartaa diiwaanada hal miis hal mar.

Qodobka WHERE aad buu faa'iido u leeyahay markaad rabto inaad tirtirto diiwaannada la cayimay ee shaxda xogta.

Ka tirtir xogta khadka taliska

Halkan waxaan ku isticmaali doonaa WHERE clause ee amarka SQL DELETE si aan u tirtirno xogta la doortay ee miiska xogta MySQL chenweiliang_tbl.

tusaale

Tusaalaha soo socda ayaa tirtiri doona diiwaanka chenweiliang_id 3 ee ku jira miiska chenweiliang_tbl:

Tirtir xogta adoo isticmaalaya qoraalka PHP

PHP waxay adeegsataa shaqada mysqli_query() si ay u fuliso weedhaha SQL, waxaadna isticmaali kartaa WHERE clause leh ama la'aanteed amarka SQL DELETE.

Shaqadani waxay la shaqaysaa mysql> Saamaynta jilaha amarka fulinta amarka SQL waa isku mid.

tusaale

Tusaalaha PHP ee soo socda ayaa tirtiri doona diiwaanka chenweiliang_id 3 ee ku jira miiska 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);
?>